2 Replies Latest reply on Oct 23, 2012 10:37 AM by jrpmedia

    Sub-Sorting the contents of POP UP Menu field formats

    jrpmedia

      Title

      Sub-Sorting the contents of POP UP Menu field formats

      Post

           I'm lost in the world of FileMaker Language, Jargon & Manuals :-(

           Here's what I want to do.

           I want a POP UP Menu field's content to be sub-set of another Table's Records

           I want a Field in another Table to display only those marked as Managers out of the Staff Table

      Can anyone explain how to do that, in simple English please ?

        • 1. Re: Sub-Sorting the contents of POP UP Menu field formats
          philmodjunk

               First, to identify the Jargon:

               This is called a conditional value list. You can sear your training materials for any info on this term that might be present.

               There are two ways to set this up:

               Option 1:

               One method uses a calculation field and permanently specifies a specific subset of the values. If you want only Staff marked as Managers and never any other group of values from the staff table to appear in the value list, this is the simplest option to use.

               Option 2:

               A second method uses a relationship to filter the values to a specific subset. Since a relationship matches values in 1 or more pairs of match fields, this option can allow you to match to different subsets of values by specifying a different value in one of the match fields. If you want the user to select "managers" in one field in order for a value list in a second field to list only managers, this option should be used.

               See this thread for a tutorial on both Options 1 and 2: Custom Value List?

          • 2. Re: Sub-Sorting the contents of POP UP Menu field formats
            jrpmedia

                 Thank you, again! :-)

                 As my Dad always said;    "The Question's in the Answer."      :-O