Creating multiple choice field that filters inputs based on input of another field.

If data entry is on a form and not by grid edit, the easiest to do this is to have Three fields for Field 2.

one will be call [Field 2 for A] with it's choices
the other will be called [Field 2 for B] with its choices.
Those two will show in Edit / Add  mode on the form.

Then in View mode show a formula field called [Field 2]

Case({field1],
"A", [Field 2 for A],
"B", [Field 2 for B])


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------