two tables, one report

[loki]

I have two forms contected together by an id number from form A. I have generated a report showing all the info from form A. How can I also show the info from form B on the same report.

 

[Chris RR]

Create a query that joins the two tables, save it, then build your report on that query.

Here's a hint. Create and save that query, then you may be able to just change the control source of your existing report to the query, instead of the table. Add the new fields & you are done.

 

[loki]

Thanks for your help Chris RR