0

Table Links

I have 2 tables, 1 called "Sites" and 1 called "Contacts". I need to link users in the contacts table to the site they are responsible for in the sites table. Every time I have tried so far once I select the contact for a site I can't then use the same contact again for another site they are responsible for. Any suggestions to what I am doing wrong would be greatly appreciated 

 

Ben 

1 reply

null
    • Alain_Fontaine
    • 3 yrs ago
    • Reported - view

    It seems that you have created a 1:N relation between "Sites" and "Contacts". By definition of such a relation, a contact can only be in relation with one site, while a site may be in relation with several contacts. So, once a contact has been added to the list for a site, it becomes unavailable.

    If you need to represent M:N relations, you must define a third table. This table need to have 1:N relations to the two existing tables. Each record in that third table represent the fact that a record in the "Sites" table is related to one record in the "Contacts" table. You may call this table, for example, "Responsibles".

Login to reply

Content aside

  • 3 yrs agoLast active
  • 1Replies
  • 293Views