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?
Thanks in advance for any help.
Peter.
--
Peter Ryder Joseph-Ressel-Str. 7, 28357 Bremen, Germany
Tel. +49 421274953, mobile +49 1636284953
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
