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.