Get same found set in related files

[Joe H]

File A and File B are related. I have a script in File A that finds a particular set of records from a drop down menu. How can I get File B to also show only that found set without having the user perform a 2nd find in File B?

[-Queue-]

This was discussed recently, albeit for version 7. You can use the same method though. See this post for info and reply with any questions you may have about it.

Update: actually that thread is similar yet different. The idea is the same, but the execution will be different, as well as where the multi-key is pasted. I'm fairly certain there is a recent thread that deals with found sets instead of a portal, but I can't locate it right now.

[-Queue-]

Okay, here's a sample of how you can do it. Play around with showing all records, then omitting some and performing the 'Go to found set in Child' script. Note the two hidden layouts which you can access by going into Layout Mode and flipping through the rolodex. After you've performed the script with more than one parent record found, go to the gtext layout and click into the field to see how the Copy All Records step returns a carriage-return delimited list that is Pasted into the global field, creating a multi-key for the GTRR step.

RetainRelatedFoundSet.zip

[Joe H]

I stupidly never thought of "copy all records". That's the key. I've been working on this same project for over 2 years. Almost finished. Have submitted 3 or 4 questions during that time. Each question was answered and enabled me to successfully move on. What a pleasure knowing you folks are so willing and able. Thanks.

[jtscott]

I'd like to repeat the same found in two files/tables, but it will select different records in file B as file A. Any ideas how I can this easily?

[-Queue-]

By different records, do you mean they won't necessarily be related? Is the find criteria manually entered or stored in a script?

[jtscott]

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 do a 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?

Any help gratefully received!

[Fenton]

It seems to me that you have (at least) 3 "entities" (things :-), Students, Classes and Reports. I wish you'd say what exactly these "reports" are; do mean like a "grade" for a particular class? "Reports" is a generic term, with no specific meaning.

In any case, I don't think you need a Find. Each Student and particular Class should have a unique ID (if they don't yet, then you can "serialize" them; but that's another post).

If you were in a Student record, then you'd need to choose the Class; visa versa if you were on a Class record. This would likely be done by clicking in a portal, say a portal in a Student record, based on StudentID to StudentsClasses <--This is a "join" table; you must have it, with a record for each unique student-class combo (maybe this is what your "reports" are, where your grades are?).

Clicking on the portal row would set the ClassID into a _gClassID global field. The relationship would then be based on the StudentID AND the _gClassID, to the many table (whatever it is). You can use:

Commit Records/Requests

Go To Related Record ["relationship", show only related records]