Return to FileMaker.com
I would like some help as I can't get my head around this.
I have two tables, "SMR"and "SMRSummary", I am creating a report where the output include all record from "SMR" table and only those records from "SMRsummary" where the joined field are equal.
Joined feild are
SMR_recordID and SMRsummary_smrID
It might be a simple solution, but I'm not getting all the records as expected.
Can anyone advice.
I'm afraid your description isn't very clear. Can you explain what data these tables contain?
Also note that a report is usually based on a list layout, and you cannot include related records (which I read 'where the joined field are equal' to mean) in such a list as discrete records.
Retrieving data ...