Skip to main content

Hi,


I am trying to create a Procurement base where can add product pricing for many suppliers and see the price side by side on in one table so we can review quickly.


I have a table for each supplier containing the same product data but one different is the price.

It sounds like you might need three tables:



  1. Suppliers: basic info about each supplier

  2. Products: basic info about each product which remains the same regardless of supplier

  3. Pricing: a table which has a link to Suppliers and a link to Products, where each row contains info on one supplier’s price for a single product

Reply


Terms & Conditions