Products from multiple suppliers.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top