Forum Discussion
Laura_Thacker
7 years agoQrew Commander
It's probably called many things; but yes a "bridge" would be an appropriate label for it.
You simply build two relationships to your Organization Contacts table to "connect" your two parent tables. So each record has two related-reference fields that you populate. Depending on what parent-table you start in to create the Organization Contact, that parent-table can auto populate one of those relationships for you; so you are only populating the other relationship manually.
Then add to each relationship the data from those parent-tables (that you want) as Lookup fields so each record in your Organization Contacts table displays both the Organization information as well as the Contact information that you have added as Lookup fields from the two parent-tables via the relationships.
You simply build two relationships to your Organization Contacts table to "connect" your two parent tables. So each record has two related-reference fields that you populate. Depending on what parent-table you start in to create the Organization Contact, that parent-table can auto populate one of those relationships for you; so you are only populating the other relationship manually.
Then add to each relationship the data from those parent-tables (that you want) as Lookup fields so each record in your Organization Contacts table displays both the Organization information as well as the Contact information that you have added as Lookup fields from the two parent-tables via the relationships.