2 Replies Latest reply on Oct 4, 2015 5:36 AM by BrentJohnson

    Using Pop-Up Menu & Value List

    BrentJohnson

      I have a field Number_Shoes that is a Pop-Up Menu with a Value List numbered 1-25.  I have a second field Number_Shoes_Broken.  I am using a Pop-Up Menu with a value list and would like this value list to be limited to the number chosen in field Number_Shoes.

      Ex:

      Number_Shoes is selected to be 8, Number_Shoes_broken Pop-Up Menu will be numbered 1 - 8.

        • 1. Re: Using Pop-Up Menu & Value List
          vavo

          Hi,

           

          If you want to have dynamic value lists you need to think relationships.

          What I would do is probably:

           

          Create a utility table called NUMBERS (or anything else) with 25 records and just one number field "NUMBER_FIELD" in each record with the numbers 1 - 25.

           

          Then create a relationship from your main table to NUMBERS. Define that relationship to be

          Number_Shoes => NUMBER_FIELD

           

          Then define your second value list with all related values from NUMBERS.

          Now when you select a number in Number_Shoes the second value list will only contain numbers that are smaller or equal to that Number.

          • 2. Re: Using Pop-Up Menu & Value List
            BrentJohnson

            vavo,

            That was the solution I needed - thank you much!