How to put linked tables in a report??

[rickyfong]

I got a invoice master file linked to transaction file. As such, for a report printout, I need to print out the master record data plus a few transactions related to that master reocrd. How can I involved these 2 linked file information in the same report using report builder?? Thanks!!

 

[John Big Booty]

You will need to create a query to draw together all the information (from the various tables) you wish to display in your report. Use that query as the Record Source for your Report.