conditional value list

[jim shelton]

I need the value list to change based upon the contents of another field.

If Field A = US then value list for Field B needs to offer Yes or No.

If Field B = Canada the value list for Field B needs to be No only.

thanks,

Jim

[TheTominator]

The solution in this thread may help.

http://fmforums.com/forum/showtopic.php?tid/214264/post/354251

[LaRetta]

A conditional value list shouldn't be necessary here. I would create a value list with Yes and No values in it and attach it to Field B. I would attach a radio button to the field. And then in Auto-Enter for Field B, enter 'by calculation' and uncheck 'Do not replace existing value if any' and put this in the calculation box:

Case ( Field A = "Canada" ; "No" ; Field B )

In this way, if/when Field A shows Canada, Field B will automatically change to a 'no' selected in the radio button. But otherwise Field B will remain empty (if it was empty) or retain the 'user-entered' value if not empty.