+1I build 3 tables:
First table for suppliers: supplierId, supplierNmae.
Second table for products: productId, productName
Third table for the link between suppliers and products: supplierId (link to suppliers table), productId (link to products table), price (the price of the product that supply this product).
In relational data base that what I need to buid.
Is that what I need to do in Airtable data base?
+17You can link the suppliers and products tables directly without a joining table. Just create a new field in products, choose the field type “link to another record”, and select the suppliers table.
+32If each product can have multiple Suppliers and different prices then yeah you’d need a third table called ‘Prices’ or something where each record represents a single Product for a single Supplier
If each product can only have one Supplier and one price, then just the Suppliers and Products table is fine
+1No, I dont think so.
I think you wrong, because the price of first supplier is differnet from secod supplier.
In relational data base we must add a table with the fields: PK of suppliers, PK of products, price that present the price acording to supplier and product. The primary key of third table is PK of supplier + PK of product.
Am I worong?
+1Dear (Sorry, but I dont know your name),
I think you right and I must have third table.
Thank a lot
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.