Bi-directional relationships
I need to know if there is anything wrong or dangerous having a bi-directional relationship between two tables. I have relationships already established as follows: Customers have many Contacts ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThat won't work. That is because if an Opportunity has Many Contacts, then conversely a contact may only belong to One Opportunity. So once that Contact gives you an opportunity you are stuck and that Contact can never give you another opportunity.
What you want is a new child table for a many to Many Relationship called Opportunity Contacts.
One Opportunity has many Opportunity Contacts
One Contact has many Opportunity contacts.
That Many to many join table will not have any data entry fields of its own, it will just have fields from the relationships.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
What you want is a new child table for a many to Many Relationship called Opportunity Contacts.
One Opportunity has many Opportunity Contacts
One Contact has many Opportunity contacts.
That Many to many join table will not have any data entry fields of its own, it will just have fields from the relationships.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------