By default, FileMaker works based on what I like to call an "implied found set". Each relational join "implies" a set of records that are related.
In your case, the join from Customer to Project includes all the projects associated with the current customer record. When you then tell it to go to all related Timesheet records, it includes all timesheets associated with any project attached to that customer - which you have discovered.
FileMaker has no way of knowing which project you want if you just use GTRR. So you will have to tell it. You can use a couple of different methods:
1) Capture the ID of the project you want in a variable, perform a Find for the project on a Projects layout, and then do a GTRR from there to Timesheet.
2) Create a global field in Customer and another set of relationships, connecting that global field to the Project ID, and then on to Timesheets as you have it now. Use a script to capture the project ID in the global field, at which point that relationship points only to the selected project, so GTRR will work.
3) Capture the project ID in a variable, and then just perform a Find for the desired project on a Timesheets layout. (Probably the easiest.)
Set up a subsummary report based on the Timesheets table.
Do a find either by date or date ranger for all customers or by customer id or customer ID and date ( or date range ) for a specific customer.
Add two subsummary sections. The first displays customer information. Use Sort by Customer name,
Add a second for the project using sort by Project name.
Customer information should be placed in the Customer subsummary section and Project information in the Project subsummary section.
You need to change layouts first, then perform the find.
Don't use Find [ Restore ]. We can't see what you're doing. Do this instead:
Enter Find Mode [ ]
Set Field [ CustomersProjects(etc.)::ProjectID ; Value: $projectID ]
We also need to know what table occurrence the "Print Timesheet Layout" is based on.
Thank you Mike. Amazing explanation.
Many Thanks for time and help