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

    show related records from child and parent table




      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