muhammad.ikram@contedia.com

show related records from child and parent table

Discussion created by muhammad.ikram@contedia.com on Oct 31, 2016
Latest reply on Oct 31, 2016 by 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

Outcomes