Creating reports based on two tables in access 2000

When creating reports/queries in Access 2000 how do you include selected records from one table then below that show selected records from a different table. Eg produce a report showing the transactions of a particular entity recorded in two seperate tables.

 

Matthee,
I think you are talking about sub-reports. Ie, you want to display all of the dates and times that customer smith came into a store?

To do this I usualy work backwards and create the sub report first. This can be based on any table you have in your database, and it should be relatively simple. Have the relational field in thios report, but not visible.

Then create the main report and its layout and choose sub report from the toolbox icon set and follow the onscreen promts, making sure that the master and child fields are what you wanted to link.

Hope this helps

Cheers

Jedel