I am trying to figure out validation on a field. I have a drop down list with the option of selecting "other". I then have a field next to it that I want the user to enter what the other is. I don't want the user to be able to enter data in the field unless "other" is selected. (I want to force the field to be blank unless the dropdown on the other field is set to "other")Do you have any suggestions or can send me to another thread that I can find the info? Thanks!

Cin

Well, there are a few ways:

1) The simplest would be to remove the option from your Users and, if they put something into field2 when the dropdown says anything besides 'other' then simply delete anything in field 2. You would do this by adding an Auto-Enter (field Options) by calculation of:

Case ( dropdown = "Other" ; Field2 )

... and be sure to uncheck 'Do not replace existing value...' on the Auto-Enter tab.

2) Use an invisible one-row portal ( Visibility Trick).

3) Use field-level validation (my least favorite in this situation because it can be annoying to Users).

LaRetta