Creating Report using 3 or more data files
It is a few years since I used Filemaker and brain is failing me.
I have 3 data files which contain varying client information, eg dentist, staff, hygienists with the common field being client code which is entered for each element relating to the owner.
What I need to be able to do is when building a report and performing a find, is enter the client number and the report contain all of the relevant dentist, staff, hygienist information relating to that particular client code.
Now if there is only 1 entry in each database against a client code I don't have a problem, it's when there are multiple entries I can't figure out how to sort the lookups to copy all info.
Can anyone help - please speak in layman's terms!