Forum Discussion
Reciprocate Relationship - how to setup
I think I almost have this...and then I don't. I'm creating a db that has a single 'Contact' table (ContactTbl - think 'Customer' table or 'Entity' table...). The table has both Organizations and In...
cross posting on:
Reciprocate Relationships...automatically - how to setup
1 table is not sufficient for your situation.
1 person can have many companies
1 company can have many persons.
you need Company table, Person table, and the Junction table.
Company table:
OrgID (long, auto)
OrgName (short text)
Person table:
PersonID (long, auto)
FName (short text)
LName (short text)
you will need to save the "many" side to the junction table.
junction table will include:
OrgID (long)
PersonID (long)