I'm using an Access database that has three tables:

Books (PK: BooksID)
BookAuthor (junction table, Keys: BookID and AuthorID)
Authors (PK: AuthorID)

A book can have multiple authors and an author can write multiple books, so I've added the junction table. Now, I have a form where I can view book records or add new records. The problem is with adding new records. Now, each book can have multiple records, so I'm wondering how I could allow the user to enter new author information while still maintaining the book-author relationship. Any help will be appreciated.

Evil. :-)