Field 2 conditionally active based on Field 1
I want a field to be available for data entry conditional to the result of a (previous) field.
if the answer to "LIKE_FRUIT" is "Yes", I want the field "WHICH_FRUIT" to be active
if the answer to "LIKE_FRUIT" is "No", I want the field "WHICH_FRUIT" to be in-active
In other databases, we call these OCI (Only Collect If) conditions
I have played around with field validation but couldn't get this to work - any tips would be helpful! :)
**I can't use a script as this DB will be used via IWP primarily