Your relationship info looks correct, but is incomplete. What tables (or more specifically table occurrences) are specified in that relationship?
Then you have what appears to be a list view layout. On what table occurrence is it based? (What is selected in "show records from" in the layout setup dialog for this layout?)
The relationship works well as the means for displaying the specified data in a portal, but if you want the data as your layout's found set, some additional work is needed to use that data and relationshp to pull up the records you want for your layout.
The two tables that I am dealing with are the Main Client Data and a copy of Invoice table now labled Invoice status. The table occurence that the report is based on is Invoice Status.
Ok, then if date start, date end and status are fields with global storage specified, you can use the following script to pull up your report:
Go to layout [Client Status] //sets correct context for the next script step
Go To Related Record [Show only related records; From table: Invoice status update ; Using layout: "Invoice status update" (Invoice status update)]
Thank you for your assistance. I've got it working.