AnsweredAssumed Answered

Creating Report using 3 or more data files

Question asked by Lisa on May 6, 2010
Latest reply on May 7, 2010 by philmodjunk


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!