Products from multiple suppliers.

P

Phil

Using the simple example from MS' course "table that data". how do I
represent that I can get a product, Chai for example, from more than 1
supplier, both Exotic Liquids and Pavlova, for example.

Thanks.

Struggling newbie
 
A

Allen Browne

If you sometimes source a product from mulitple suppliers, and suppliers
also provide multiple products, you have a many-to-many relation between
products and suppliers.

Instead of s SupplierID field in the Product table, you will need another
table with fields:
SupplierID who supplies this
ProductID what is supplied.
If a product has 2 suppliers, you have 2 records in this table.

To interface it, your Products form will have a subform where you can enter
as many suppliers as you need for the product, one per row.

Similarly, you can add a subform to your Suppliers form. The subform is
bound to the new table, and shows the products that supplier provides, one
per row.

If you need to filter these forms, see:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top