AnsweredAssumed Answered

how can I write a "find" script based on three different field selections?

Question asked by MNV on Feb 14, 2011
Latest reply on Feb 16, 2011 by philmodjunk

Title

how can I write a "find" script based on three different field selections?

Post

I am creating a find layout in FMP (using FMP 8) in which I want the user to select from a drop-down menu from Field 1, which will then make Field 2 display only those records that correspond to the Field 1 selection, and then in turn will make them select a choice from Field 3 and THEN display only those records that meet all the conditions.
Ex:
-  Field 1 possible selections: A, B, or C
-  Field 2 possible selections: 1 through 12 for A, 13 through 16 for B, and 17-25 for C
-  Field 3 possible selections: yes or no
If the user selects A from Field 1, then Field 2 gives them only 1 through 12 from which to select.
Once they select a number (ex: 6), then Field 3 will let them choose yes or no, and then the find will display the correct records.

Does this make sense?
Thanks in advance!

Outcomes