how can I write a "find" script based on three different field selections?
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.
- 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!