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

    Re: database relationship

    rayhenriette

      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

        • 1. Re: database relationship
          erolst

          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.