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.