AnsweredAssumed Answered

Script to use a find result as source for new search

Question asked by PeterW45 on Jan 31, 2012
Latest reply on Jan 31, 2012 by PeterW45

Title

Script to use a find result as source for new search

Post

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]
 

 

 

Outcomes