Books and Authors Form?

[PWB61]

I am creating a library database. I have three tables, tblBooks, tblAuthors and a joining table, tblBooksAuthors so that one book can have many authors, and vice versa.
I am trying to create a form to enter information into both tables, I have tried making a form on the tables, but using Books with a subform for Authors, when I go to enter the author of a new book, I get the error message that the field cannot be updated.
If I make the form based on a query, I can only enter one author for that book.
Anyone able to direct me to relevant information so that I may be able to work this issue out?

 

[Mile-O]

BooksToAuthors should be the basis for your subform. If the parent form is to do with books, you can link the two on the BookID. Likewise, if the parent form is the authors one; you can link the two on AuthorID.

 

[PWB61]

Thanks

BooksToAuthors should be the basis for your subform. If the parent form is to do with books, you can link the two on the BookID. Likewise, if the parent form is the authors one; you can link the two on AuthorID.

Many thanks for that help. Should have realised that it was the new millenium and that the child would control the parent, not the other way.