AnsweredAssumed Answered

Multiple Join Tables

Question asked by DanHarris on May 25, 2016
Latest reply on May 25, 2016 by Mike_Mitchell

I'm a bit stuck here, hoping for some help.  My current solution has two main subjects, Organizations & Contacts.  I've created a join table between them to take care of the possible many-to-many relationship.  But, I've also created an Addresses, and a Phone Numbers table that need to be related to these main subjects. These relationships will be many-to-many as well (a phone number could belong to many Contacts and/or Organizations as could an address).

 

I'm having trouble wrapping my head around the ERD for this database, as well as the correct table structure within FM.  Will I need multiple TOs of these main subjects?

Outcomes