Relationships design Q 1

LMichel · Apr 9, 2001

I've defined two tables:

One table with products information
One other with departments information

A product is used by more than one department.
A department uses more than one product.

ex:
Product1 is used by
- Department A
- Department C

Product2 is used by
- Department A
- Department B
- Department E

How do I define the relationship between these two tables ?

ghubbell · Apr 9, 2001

Hi L Michel,
If you want to firmly define that one dept. uses many products and one product "uses" many departments, you'll have to add another table. This table would contain the deptID and the productID. The two together can make up the primary key for this table in the event this is just used to control "who gets what". Add another field say "deptprodID" as an indexed field, no dups, (autonumber would do) on this table and you can now use it to monitor usage of products by departments in a "usage" table. HTH

Gord
ghubbell@total.net

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Relationships design Q 1

LMichel

IS-IT--Management

ghubbell

Programmer

Similar threads

Part and Inventory Search

Sponsor