Relationships design Q 1

[LMichel]

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]

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