show related records from child and parent table

Discussion created by on Oct 31, 2016
Latest reply on Oct 31, 2016 by



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