Are you using fileMaker 11?
If so you do not need that added table.
This can be a list type summary report with filtered portals to organize the data into columns.
Using your screen shot for a reference. The first two rows (the performer's name and the column headings) would be a sub summary part "when sorted by Performer".
You'd then place the performance date formatted to show day of the week in column 1 of the body, leave space for the gap below the performer's name and then add 8 one row portals to your table, each with a filter expression to filter only for a specified act.
Your portals' relationship would look like:
Table::PerformerID = Table 2::PerformerID AND
Table::ShowNumber = Table 2::ShowNumber
I am using a performerID serial number here as PerformerNames are both non unique and subject to being changed where this is not the case with an ID number. (and should come from another table with one record for each performer.)
That works a treat.
Is there then any way to limit the results I get in the sub summary part to only show the last five shows for each performer??
Thanks very much for your help
Yes, you should be able to perform a find to limit your found set to only those shows.
Thanks a lot for your help.
I now have that working my only issue now is that when I define my find, I end up with many records for each show.
Is there a way to limit the find so it only shows one record per show??
I have tried constraining the found set to not show duplicates but it appears each record is unique.
Cheers for any sugestions
We need to make a small change to this part: Quoting from an earlier post: Using your screen shot for a reference. The first two rows (the performer's name and the column headings) would be a sub summary part "when sorted by Performer".
Make the part of the layout where these portals are located a sub summary part when sorted by your Performance field and remove the body part from your layout altogether.
This approach will then "condense" all your individual performance records down to one row per performer per performance. (Make sure that you sort your records both by performer and then by performance.)