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