E
Edgar Thoemmes
Hi
I have a database which is tracking old books. I have the following tables:
tblBookDetails(BookId, ISBN, Title, Description) tblAuthors (AuthorID,
Title, FirstName, LastName) and tbl Book/Authors(BookId, AuthorID)
Basically any book could have multiple authors/editors so I set up a
junction table. This all works fine but I am having trouble displaying this
information in a form.
I have a form frmBookDetails which displays the contents of tblBookDetails.
I want to add the Authors and Editors into this form - I tried setting up a
list box to display the Authors/Editors but I couldn't get it to display the
correct details. Also this got me thinking about adding new authors to the
database - how would this be done with a listbox?
Can anyone point me in the right direction with the above problem?
I have a database which is tracking old books. I have the following tables:
tblBookDetails(BookId, ISBN, Title, Description) tblAuthors (AuthorID,
Title, FirstName, LastName) and tbl Book/Authors(BookId, AuthorID)
Basically any book could have multiple authors/editors so I set up a
junction table. This all works fine but I am having trouble displaying this
information in a form.
I have a form frmBookDetails which displays the contents of tblBookDetails.
I want to add the Authors and Editors into this form - I tried setting up a
list box to display the Authors/Editors but I couldn't get it to display the
correct details. Also this got me thinking about adding new authors to the
database - how would this be done with a listbox?
Can anyone point me in the right direction with the above problem?