6 Replies Latest reply on Oct 31, 2016 9:35 AM by muhammad.ikram@contedia.com

    show related records from child and parent table

    muhammad.ikram@contedia.com

      Hello,

       

      I wounder if anyone could help me with this.

       

      I would like to show related records from child and parent table. FOR EXAMPLE

       

      The table structure above is

       

      Customers          Projects            Timesheets

       

      A customer can have many project; each project has a Timesheet.

       

      I want to print Timesheet(which shows project activities) of that specific project which belongs to that customer. I have set up a print layout and used SHOW RELATED RECORDS script which works fine. The PROBLEM is it will show all the timesheet of that customer and projects.

       

      How can I show related records from two tables so it would ONLY show me the timesheet of that project and customer.

       

      Thanks in advance