Multiple 'Many to Many' Relationships, should I use an Instance?
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?