I am having a dilema with relationship(I think that's my problem).
I am trying to set up a simple database (maybe), just to keep a reading log
of books that I checked out from my local library. But not having much luck
setting up a database. I want to establish a relationship between ; BookID,
AuthorID and Author name. Is this possible?? The bookID, AuthorID and Author
name will be the same for each new book. But at the same time I understand
that one Author will have many or more than one books. I want the form to
open in Books and Author as a subform. Do I need to include AuthorID in the
book form when I am designing my form??
This is what I have been trying to do as my table:
Books Author category
BookID AuthorID Fiction
Title Author Name Non-Fiction
Date Read
Date Checked Out
Date Returned
(any of course some other minor fields)
Are there any fileds that should be included in any of the tables that I
haven't done to set up the relationship, that will make this work (If at all
it can be done as I am thinking)
Thanks a million
--
stainless steel