I need to develop a report that lists the centers and all the patients that belong to that center along with their laboratory results. The report should pull the data from the following tables:
Patients
Centers
Laboratory
All contains a linked field: Patient_id
How can I set relation to all three tables so that once finds all the patients in one center, it'll just move on to the next...
TIA
Jeff T.
Thanks in Advance.
J. Turner