Primary Contact checkbox in Vendor Contact


(system) #1
That worked.  I joined Vendor and VendCnt tables where Vendor.PrimPCon is equal to VendCnt.ConNum and it gave just the contacts I need.  Thank you.

(system) #2
I am trying to create a report on Vendor Contacts and I need to know which one is the primary contact.  The Primary Contact field does not exist in the VendCnt table and I couldn't find it anywhere else.  Can someone point me to the right direction?  Thank you.

(system) #3

I'm not sure but don't think the check box exists as a field... I think the Vendor table is updated with the ID of the Primary contact as it means the table can only hold one primary. 



---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

I am trying to create a report on Vendor Contacts and I need to know which one is the primary contact.  The Primary Contact field does not exist in the VendCnt table and I couldn't find it anywhere else.  Can someone point me to the right direction?  Thank you.

(system) #4

 tracy.tmat is correct. The vendor table has a field named "primpcon" which hold the contact number for the primary contact. This links to the vendcnt table using vendornum and connum key fields. Hope this helps. 



---In vantage@yahoogroups.com, <tracy.smith@...> wrote:

I'm not sure but don't think the check box exists as a field... I think the Vendor table is updated with the ID of the Primary contact as it means the table can only hold one primary. 



---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

I am trying to create a report on Vendor Contacts and I need to know which one is the primary contact.  The Primary Contact field does not exist in the VendCnt table and I couldn't find it anywhere else.  Can someone point me to the right direction?  Thank you.

(system) #5

That is correct. In the Vendor table there is a field PrimPCon, which holds the (integer) value of VendCnt.ConNum  where the Primary box has been checked. I understand their logic in doing it this way, but it really is a mess to try and do anything with.

 

Ernie Lowell

Diba Industries



---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

I'm not sure but don't think the check box exists as a field... I think the Vendor table is updated with the ID of the Primary contact as it means the table can only hold one primary. 



---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

I am trying to create a report on Vendor Contacts and I need to know which one is the primary contact.  The Primary Contact field does not exist in the VendCnt table and I couldn't find it anywhere else.  Can someone point me to the right direction?  Thank you.