We need to know how you have currently related your two tables.
If you have a relationship like this:
Bowlers::BowlerID = Details::BowlerID
You can set up a list view layout of your bowlers on a layout based on Bowlers with a portal to Details in the body. If you can set up a sort order that sorts the most recent frames to the top of your portal, you can show the most recent 10 frames by limiting each portal to 10 rows. A more detailed scheme with a portal filter can also be used, but we'd need to see more details about the data your are recording in the details table before we could suggest much in terms of a filter expression.
I do have the relationship setup like you indicated. I have each record timestamped, so I can sort in desending order to get the most recent frames.
I don't know why I didn't think of doing that (I am use 2 portals on the screen we enter the statistical information on to display updated overall statistics for each bowler and the last 5 frames bowled).
I don't know why I didn't think of doing that
You may have had a built in blind spot from your prior experience with Access.
Don't know if this is still true, but in the versions of Access I used to use, this type of layout design wasn't possible as Access didn't permit using a "subform" (the access version of a portal) on a list of records type form, only in a form set to display one record of a time like in FileMaker's form view.
Probably.. I am slowly getting more proficient with Filemaker (I just started using it over the summer). For what we wanted, it was the only real choice. We are using iPads to collect the information at tournaments and transferring it to a desktop for manipulation (which I still use Access for since I have over 10 years of development experience with it).
I am on the 4th version of the Filemaker database and I keep adding new features as other members of the coaching staff provide suggestions.
Hopefully by next season I will have everything inclusive in Filemaker.