AnsweredAssumed Answered

Multiple 'Many to Many' Relationships, should I use an Instance?

Question asked by brian.curran on Mar 30, 2011
Latest reply on Mar 30, 2011 by brian.curran

Title

Multiple 'Many to Many' Relationships, should I use an Instance?

Post

Hi,
I currently have the following:
[Contacts] <---[Contacts_Addresses]---> [Addresses]

This Many to Many relationship allows me to allocate each Contact a Role (or several Roles) and assign that contact to an Address,

However, some Contacts need to be assigned to several Addresses so I was thinking of adding a join table as follows:
[Contacts] <---[New_Join_Table]---> [Addresses]

This will result in these two tables having two separate Join tables! Will this work ok or should I use Instances of the tables?

Thanks
Brian. 

Outcomes