If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Setting a many-to-many relationship
I've taken the strong advise of many in this forum to create a single table
for my business Contacts - whether they be vendors, customers, employees, vendor's employees, etc. Now each order that we receive has many Contacts (each order will have a customer company, a customer sales rep, a vendor, and multiple of my employees that handle the order in its various stages) and each Contact will have many Orders. With this in mind, I'm ready to set a relationship between my Contacts and my Orders tables and am not sure how to structure this in my junction table. My goal is to leave myself with the most flexibility with the db as possible for future growth and changes. Thanks in advance! |
#2
|
|||
|
|||
Setting a many-to-many relationship
toolman74 wrote:
I've taken the strong advise of many in this forum to create a single table for my business Contacts - whether they be vendors, customers, employees, vendor's employees, etc. Now each order that we receive has many Contacts (each order will have a customer company, a customer sales rep, a vendor, and multiple of my employees that handle the order in its various stages) and each Contact will have many Orders. With this in mind, I'm ready to set a relationship between my Contacts and my Orders tables and am not sure how to structure this in my junction table. My goal is to leave myself with the most flexibility with the db as possible for future growth and changes. Thanks in advance! You can subclass the various contacts. Here's an article that explains it: http://www.mvps.org/access/tables/tbl0013.htm Rebecca did such a nice job explaining it that I don't think I'll muddy the waters by adding my two cents... -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|