I am an Access user switching to FileMaker Pro. I need to have a single report from a main table that pulls multiple records for other tables. I can only get one record to pull over. I have set up the proper relationship (one to many).
For simplicity, I have a patient table and a table of their medications. One patient, multiple medications.