Hello Peter Peter Ryder schrieb: > Dear all, > > I am a newbie to OO Base (and data base programming in general). I am > trying to create a data base for a book collection. So far I have two > tables: "books" and "publishers". The "books" table has a field > "publisherID" which is linked to the primary key of the "publishers" > table. So far so good. Now I want to do the same for the authors. The > problem is that many books have more than one author, so I have the > fields "author1", "author2" etc. in the "books" table. Now if I have a > table "authors", the assistant will not let me link its primary key to > all the author fields of the "books" table, but only to one field. I > assume there is some good reason for this. So do I have to have separate > tables for "author1", "author2" etc., or is there a solution which > requires only one table of authors?
Your are German? so http://mechtilde.de/ooodatenbank/datenbank.html can help you There I describe an example for a migration. But I use books and authors to describe it. If you have more questions, please ask. There is also [EMAIL PROTECTED] for German speaking people Regards Mechtilde --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
