Report creation in design view

[bobby]

Guys, i have a form where the user selects a football club, for example : Liverpool.

When they click the View button or whatever, i want a report to show up showing all the teams that Liverpool have played.

In the report i can get it working when there is just one source, e.g. just one table. But i need more than one table to be involved.

How would i go about doing this ?

 

[Navyguy]

I would be using a qry to populate your report and in the qry select the required fields you want to see in your report.

Be sure to "Add Tables" in the top section of your qry and when selecting the required fields from the tables, just drag and drop into the next col in your qry design.

You will have to change the source of your report from table (tblMyTeams) to (qryAllOfTheTeams) or what ever they are called.

Hope this helps