Forum Discussion

BobWagstaff's avatar
BobWagstaff
Qrew Trainee
9 years ago

Populating form field with selected values from shared field

I'm in my evaluation period and have a question.  I've built a Company and Contact table and related them.  The Company table includes a field - Company Type.  All good.  Now I'm working on another fo...
BobWagstaff's avatar
BobWagstaff
Qrew Trainee
9 years ago
And this is where I do get confused with regards to how QB is using relationships.  I understand that one Company can have many contacts and one Company Type can have many Companies.  For this table, I only have 1:1, if the Company is a CAT dealer (as designated by the Company Type), then they have one record in this table.  If I create a relationship, then is it one CATDealer to many Companies or one Company to many CATDealers?  Neither seems right to me.  Maybe Sam's approach is the most efficient?