1-to-many link

[Subhunter]

Hello,

I am trying to set up a new program here at work to help with our bidding process. The problem I am running into is linking our multiple suppliers to one component of the main product.

Product Parts Suppliers
- thingamajig -capacitor -A, B, C


-resistor -A, D, F
-diode -C, H, G

I can link the Parts to the Product just fine but when I try to build the many-to-many table to link the suppliers I keep getting a 1-to-1 relationship.

Any help would be appreciated.

Thanks,

Jeff

[TheShabz]

i would have 4 tables.
Product
Parts
Suppliers
PartSuppliers

Product 1-M Parts
Parts 1-M PartSuppliers M-1 Suppliers

you need a many to many relationship between Parts and Suppliers to make it work. The "juntion table" PartSuppliers facilitates that as Access does not have a direct Many-to-Many.