[libreoffice-users] mysterious foreign key integrity constraint violation

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 111- supplier2 222-

Re: [libreoffice-users] mysterious foreign key integrity constraint violation

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

Re: [libreoffice-users] mysterious foreign key integrity constraint violation

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

Re: [libreoffice-users] mysterious foreign key integrity constraint violation

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 ---