Forgot to say - if you do want to have the Loan Description field showing with Items being entered more than once if they appear more than once in Table 2, then have a calculated query with all of Table 2 and Loan Description from the Loan Table (call it eg QryLoanAndItems). Add this query to a new query along with the query you produced when joining all the 3 tables together (we'll call it QryResult