How to link contacts from one table to 2 different fields in another table

Topic Labels: Base design
690 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I have a companies table and a contacts table. For each company, I would like to identify their Technical Contact and Business Contact in 2 fields. I have linked fields from the Companies table to the Contacts table, but there are also 2 backlink fields in the Contacts table which I think will confuse my users. Is there a cleaner way of doing this so there aren’t 2 Company fields in the Contacts table?

0 Replies 0