If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Please help if you have the time& patience (Setting up Relationshi
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 |
Thread Tools | |
Display Modes | |
|
|