Setting a many-to-many relationship

[toolman74]

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!

 

[PieterLinden via AccessMonster.com]

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...