You could resolve this with a foreign key in the Products table (would
require a new field) in which you store the primary key of the
applicable row in the suppliers table. This way one supplier could
supply more than one product. However, this would not cover the case
where one product can
Hi Larry,
Larry Evans schrieb:
I've 2 tables:
Table:Products with ProductName as primary key.
ProductName Inventory
--- -
product1 100
product2 200
Table:Suppliers with SupplierName as primary key.
SupplierName PhoneNumber
---
supplier1
On 12/30/2013 06:39 PM, Larry Evans wrote:
I've 2 tables:
Table:Products with ProductName as primary key.
ProductName Inventory
--- -
product1 100
product2 200
Table:Suppliers with SupplierName as primary key.
SupplierName PhoneNumber
---