Script to use a find result as source for new search
I am setting up a tennis database (http://forums.filemaker.com/posts/59e6bdf9d0). I realize this comes down to a very simple flat file of the form, 1A, 1B, 1C, 1D, 2A, 2C, 2D, 2E, etc. The numbers represent a matchID and the letters represent the playerID. I want to search for a player's records and find who has played with him. That means I search for A and return the records as his matchIDs. I want to use the search result for a new search based upon those matchIDs. This is a very simple type of script and I have seen variants of it, but when I perform the script, it enters "$MatchID" into the MatchID field.
This what my script looks like:
- Enter Find Mode[Pause]
- Set Variable [$MatchID; Value:Tennis DB::MatchID]
- Extend Found Set[Restore]