Forum Discussion

DanniDanni's avatar
DanniDanni
Qrew Member
10 years ago

I have a company table and a contact table. How do I link all contacts to related company automatically? Thank you!

I have a company table with all the company info, and I have another contact table with all the contact in each companies. How can I make the contact link to the assigned company automatically instea...
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
10 years ago
Well then your only solution is to make the Key field of the Companies table to be the Company name.  Then make the relationship to the Contacts be based on the Company name in the contacts record.
SteveHanson's avatar
SteveHanson
Qrew Trainee
7 years ago
Can you explain how to do this. I'm in the same boat. I imported organizations and contacts separately into two different tables. I would like the contacts to appear in the form for organizations.