How to validate one field based on another

[BeckyMN]

Hi!

I'm new so forgive me if I'm breaking a rule right off but I have a problem that I would really like to get solved.

I would like to be sure that FieldA contains a value, any value, if FieldB contains only a certain value. I think this could be done with field validation but I'm not sure how to do this.

For example if the two fields were Fruit and Color, how could I make sure that the Color field contained a color (red, green, yellow) if the Fruit was APPLE? If the Fruit field was BANANA then the Color field could be blank.

I don't know how to do this. Can anyone help me?

-Becky

[-Queue-]

Validate FieldA with

not IsEmpty(FieldA) or FieldB <> "some value"

and deselect 'validate only if field has been modified'.

[BeckyMN]

I shall give that a try.

Thank you so much Queue for taking the time to answer my question!

-Becky