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+unsubscr...@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