Use pairings of foreign key IDs and primary key IDs. This is called a
one-to-many relation. Relations become editable by means of list boxes
without using the ID numbers. In a list box you put an ID number into
the foreign key field by selecting the respective textual info. The ID
numbers are unambiguous row references so you never store the same info
twice.
For instance:
http://user.services.openoffice.org/en/forum/viewtopic.php?t=38452&p=176682#p176682
Hope this helps,
Andreas
--
Unsubscribe instructions: E-mail to [email protected]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
