10 Replies Latest reply on Mar 30, 2011 3:38 PM by brian.curran

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

    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.