Autofill report fields

[gcomp]

I have a query that returns all the data I need for a report. PO data is stored in Table1. One of the fields in Table1 is VendorName. The address and account info for that vendor is stored in Table2 along with the vendor name as stored in Table1. How do I get the address, city, state, zip and account number info that are stored in Table2 to auto fill the correct fields in the report?

 

[JamesMcS]

Create a query that shows what you want to show, then base the report on that - i.e. link the two tables together with vendor ID, pull down all the fields you want to show in the report, save it, and make that query the report's record source.

 

[gcomp]

Thank you for your help. It worked just like it is supposed to.