Multiple tables in one report

[Mental]

Hi,

I want to create a patient report and have no idea how to do it. I've attached the file. There are 4 tables. Patient Chart, Encounters, Scans, and Medications. The ideal report would print the chart first, which is just one page of demographics. Then it would print the related encounters, but here's the tricky part. Each encounter may have a scan attached to it. They're related. This is nice because it's easier to just snap a picture of the injury then spend all night describing it. Anyways, the ideal report would print each encounter with all the related scans. Finally, it would spit out the related medications that I've given. I've broken the database way down to basics to reduce download time and make it simple to work with. There are many scripts that automate the data entry but those shouldn't be relevent to printing. Any help would be so very much appreciated. Thanks!

P.S. The login and password are both "help"

MedicalRecords.fp7.zip