Report Containing Multiple Tables

[JeffreyE]

I have set up a relational database with our hospital lab. There is a table of hospital patients that is linked by medical record number to 4 other tables, each representing different types of specimens. Currently we print &quot;past-history&quot; reports for each new specimen if it is from a patient previously entered into our database. We must now print 4 separate reports, one for each of the 4 speciment tables linked to the master patient table. Is it possible to create a query that would include all data from each specimen table for a single patient, then include that data on a single report?<br><br>Thanks for your help in advance.<br><br>JeffreyE

 

[Guest_imported]

You can just imbed the other &quot;reports&quot; into the main report.

 

[JeffreyE]

Multiple queries and reports with one master report? How does one embed a report into another report?<br><br>JeffreyE

 

[elizabeth]

Use the subreport tool in the report toolbox.