Link table/References table RRS feed

  • Question

  • Hi folks, looking for some advice, I have the same product supplied by many suppliers the only difference is the price.

    I have a Products table and a Suppliers table was thinking of adding a link table. This will allow the products to have many suppliers i.e. I would only need to enter the products once into the database.

    The problem is each supplier charges a different price for the same product; do I need a price table linked to the SupplierProduct link table?

    Open to ideas

    Ps what is the difference between a Link table and Reference table, to me they are just the same thing?

    Thursday, January 15, 2015 10:32 PM