rayhenriette

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.

 

thanks

 

Ray

Outcomes