Not a good title, but I didn't have anything better. Here's the fictional situation. I have Salesmen (table) who are linked to Customers (table, one-to-many) and Prospects (table, one-to-many). I want a query with three columns... Salesman, Customer, Prospect. If I use Salesman as the Primary table and JOIN it to the other two tables, I get a huge number of rows. It lists the Salesman, then the Customer, then ALL the Prospects... then the next Customer for the Salesman, and ALL the Prospect, etc. I want to query to give me the first Salesman, the first Customer, and the first Prospect. On the next row, I want the same Salesman, the next Customer (if there is one, otherwise blank), and the next Prospect (if there is one, otherwise blank). I want the same Salesman to appear on each row until BOTH the linked Customers and Prospects are listed... then it should go to the next Salesman and do the same thing. Any help would be appreciated. Thanks, Eddie