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

On 12/30/13 18:21, Regina Henschel wrote:
> 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      111-1111
> > supplier2      222-2222
> [..]
> > However, it doesn't help with the error message because I'm
> > not trying to alter the Products table, as the error message
> > suggests, I'm trying to create a new table, SupplierSuppliesProduct,
> > containing a relationship between two already existing tables.  The
> > new table would look something like:
> >
> >    Table: SupplierSuppliesProduct
> >       with primary keys SupplierName,ProductName
> >    showing which Supplier supplies which Product.
> >
> > How should I do that?
>
> First define this third table as new table and then set the
> relationships. It is a n:m structure.
>
> Kind regards
> Regina
Ah!  Yes.  Tried it and it works.
Seems obvious now.
Thanks.

-regards,
Larry



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted