Book DB Entry Form--multiple author entry?
Hi,
I am working on a database to keep track of books and their authors. It has the following tables and fields: [tblBook--BookID, Title, Subtitle, Edited, Year Published, Location Published, PublisherID, Category, ISBN, Notes], [tblLinkBookAuthor--AuthorID, BookID], [tblAuthor--AuthorID, Name], [tblPublisher--PublisherID, PublisherName], and [tblCategoryList--Category].
I am now working on creating a form through which to make new book entries. I know I should base the form on a query which I have been working on but I am having trouble getting the form to do what I want. I want to create one form through which all of a book's information is entered.
Since a book can have multiple authors I need to include subforms. As the book's author is being entered into the form I want Access to lookup and see if the author is already in the DB and if so, then that new book entry becomes associated with that author as well. If the author does not already exist it should then be added to tblAuthor. I need to have a similar thing happen with Publisher.
The form I created does not work properly--when I go to enter the Author(s) name(s) it says "Field cannot be updated!" I have included a screenshot of the relationships in my database if it's of any use. I'd really appreciate any help I could get. Perhaps I should post my question under the "Forms" or "Queries" section of the forum. I appreciate any help I could get. Thank you in advance.
-Steve
Hi,
I am working on a database to keep track of books and their authors. It has the following tables and fields: [tblBook--BookID, Title, Subtitle, Edited, Year Published, Location Published, PublisherID, Category, ISBN, Notes], [tblLinkBookAuthor--AuthorID, BookID], [tblAuthor--AuthorID, Name], [tblPublisher--PublisherID, PublisherName], and [tblCategoryList--Category].
I am now working on creating a form through which to make new book entries. I know I should base the form on a query which I have been working on but I am having trouble getting the form to do what I want. I want to create one form through which all of a book's information is entered.
Since a book can have multiple authors I need to include subforms. As the book's author is being entered into the form I want Access to lookup and see if the author is already in the DB and if so, then that new book entry becomes associated with that author as well. If the author does not already exist it should then be added to tblAuthor. I need to have a similar thing happen with Publisher.
The form I created does not work properly--when I go to enter the Author(s) name(s) it says "Field cannot be updated!" I have included a screenshot of the relationships in my database if it's of any use. I'd really appreciate any help I could get. Perhaps I should post my question under the "Forms" or "Queries" section of the forum. I appreciate any help I could get. Thank you in advance.
-Steve
