1 Reply Latest reply on May 31, 2015 6:50 PM by philmodjunk

    How to set up a contacts table so that it can relate to more than one table

    NickRohan

      Title

      How to set up a contacts table so that it can relate to more than one table

      Post

      I want to setup a database with a Vendors table and a Customers table. Both Vendors and Customers have Contacts. 95% of the Contacts are going to be unique to either a Vendor or a Customer. But occasionally a Contact may be related to both a Vendor AND a Customer. So the question is what is the best practice? Should I set up seperate VendorContacts and CustomerContacts tables and accept the fact that some data may repeat itself? Or should I set up one Contacts table and relate it to both the Customers table and the Vendors table. And would that even work? In this example both Customers and Vendors can have many contacts. So I want a one to many relationship between Customers and Contacts (and Vendors and Contacts).