I'm working on a Library database and many of the books have co-authors. In my "Books" form, I need two combo boxes that both get their information from the "Authors" table and the form writes Title, Author, CoAuthor (If there is one) and Location to the "Books" table. The problem is, when I select an author in one combo box, it fills in the second combo box with the same author. When I select another author in the second combo box, the first combo box copies. How can I set up the two combo boxes so I can select two different authors from the same table and have them written to the "Books" table, one as "Author" and one as "CoAuthor"
Thank you!