Re: database relationship

Discussion created by rayhenriette on Apr 11, 2014
Latest reply on Apr 11, 2014 by erolst

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.