Perform previous find in related layout

[jtscott]

I have a school reports database with a one-to-many relationship - one entry in the students info table relates to many entries in the Reports table (i.e. one student receives reports from several subjects)

I have two (well more, actually) layouts - Layout A displays records from the Students table and Layout B records from the Reports table. However, when performing a search in layout A, it actually searches related fields from the Reports table (thus showing students in a particular class or teaching group, based on the reports they receive).

However, if I move from Layout A to layout B, I have to repeat the search - there doesn't seem to be a way for FileMaker to "remember" the search criteria, even using a Perform last find step. I assume this is to do with the fact that the two layouts are set up to display records from different tables...?

Q: How can I move from layout A to Layout B and retain the records in the found set (or trigger a script which repeats the find when entering layout ?

[transpower]

Put a portal for Reports in the Students layout. Add a script GTRR to go from a portal row to the associated record. When you exit that record you'll come back to the same found set in Students.

[jtscott]

I think my initial post might be a bit confusing.

1. I have a [students table] layout with a portal [to Reports table] showing all reports for a student (in a one Student record to many Reports records relationship). If I do a search here for a class or set, it selects all students in a set, but lets me view every report for every subject which that student receives via the portal.

2. I also have a [Reports table] layout. If I do a search here for a class or set, it selects all students in a class/set, showing each student's report for that particular class/set only.

However, I want to be able to my search in 1 (above), click onto the layout in 2 and automatically repeat the search criteria. However, FileMaker seems to "forget" the search criteria (I assume because each search is coming from layout based on a different table).

How can I automatically repeat the search criteria, so when I perform step 2 (above), it reselects the find requests already done in step 1?

Many thanks,

J T Scott

[-Queue-]

See if the sample file on this thread gets you moving in the right direction.