Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Displaying Data from Multiple table

Topic Labels: Base design
382 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

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