1 Reply Latest reply on Apr 11, 2014 8:18 AM by erolst

    Re: database relationship


      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.





        • 1. Re: database relationship

          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.