problem with referencing a table more than once?

[galdcourse2]

I have set up a database for a imaginery library. each member can taout
three books at a time.In the loan table I have to make three references
to the book table asking for the information of the book (such as
title, author, isbn etc.) My problem is that i can reference the book
table but it will only pick out the information for the first reference
that i make. Can anyone help me out with this .
thanks

 

[Graham R Seach]

You'll have to show us how you have the tables set up, plus the query you're
using to retrieve the information.

However, if your loan table contains 3 records, each being a borrowed book,
you should be able to return information about each book using a syntax
similar to that shown below:
SELECT tblLoan.LoanDate,
tblBook.Title,
tblBook.Author,
tblBook.ISBN
FROM tblLoan INNER JOIN tblBook
ON tblBook.BookID = tblLoan.BookID
WHERE tblLoan.ReturnDate IS NULL
AND tblLoan.BorrowerID = 123

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia