2 Replies Latest reply on May 27, 2013 3:04 PM by philmodjunk

    Conditional List to dynamically exclude value in another field

    JohnStewart

      Title

      Conditional List to dynamically exclude value in another field

      Post

           Hi All, new to filemaker and this forum after a brief flirt with MS Access!

           Trying to create a user form with drop-downs based on a simple list. The form will have multiple fields but I only want one value to be in each field. For instance. 

           List:

           John
           Paul
           Ringo
           George. 

           When the user selects one field he will get the option of all 4. However, if he chooses a value for field 1 then that value will be excluded from the drop down on the next field. 

           Field 1 (Who is your favourite beatle?):    User selects "John" from List

           Field 2 (Who is your second favourite?):    User only has option of  Paul, Ringo or George in list.

            

           Many thanks,

           John