Conditional List to dynamically exclude value in another field
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.
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.