9 Replies Latest reply on Feb 16, 2011 10:41 AM by philmodjunk

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

    MNV

      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!