Okay, I haven't download the library template, but it sounds like it is not
set up for multiple authors.
Perhaps you could set up some tables like this:
tblAuthor (one record for each person), with fields:
- AuthorID AutoNumber primary key
- Surname Text
- FirstName Text
tblBook (one record for each book), with fields:
- BookID AutoNumber primary key
- BookTitle Text
- ISBN Text
- PublisherID Number relates to publisher table
- PublishYear Number
tblBookAuthor:
- BookID Number relates to tblBook
- AuthorID Number relates to tblAuthor
- Priority Number tells which order to list the authors in
So if a book has 3 authors, that BookID will have 3 records in the last
table. The primary key could be the combination of the 2 fields BookID +
AuthorID (so an author cannot be listed twice for the same book.)
You will have a separate form where you enter authors. The form where you
enter a book will have a subform bound to the tblBookAuthor table. The
subform will be in continuous view, and you add as many rows as you need
authors for that book.
At some point, you are going to come back and ask us how you search for
books by author. When you hit that problem, see:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html
Finally, you might want to consider how disparate are the items you need to
lend. Might they include periodicals? CDs? DVDs or videos? If so, you will
need to adapt the structure suggested above to things other than authors
(e.g. producer, director, song-writer, recording studio, ...)
