"Jan :)" <abuse@localhost.invalid> wrote in message news:OC$C7IxyIHA.552@TK2MSFTNGP06.phx.gbl... Yes, I can enter the data into the recordsource table, but, nothing is showing in the query datasheet view. Here is the SQL for the query the form is based on: SELECT tblBookNames.BookName, tblBookNames.BookISBN, tblBookNames.ObtainedFrom, tblAuthorName.AuthorLastName, tblAuthorName

Hello all: And here's another wrinkle: Shelf Order. Suppose you have a multi-authored book. Whose last name do you use on the spine label? Well, you have to assign one of the authors as the "primary" author. So you need to assign not only an authorship type (author, illustrator, editor, etc.), but also indicate which of the multiple authors should be used to generate the spine label..