Howdy!

I am having trouble doing this:

If Animal field is "cat", "dog" or "rat", subcategory cannot be blank. (i.e. if Animal = "giraffe", subcategory must be blank) I am trying things like this to no avail:

(Animal = "cat" and Subcategory <> "")

or

(Animal = "dog" and Subcategory <> "")

or

(Animal = "rat" and Subcategory <> "")

or

Subcategory = ""

Any ideas would be appreciated! Thanks, Kay

IsEmpty(Animal) or Case(Animal="cat" or Animal="dog" or Animal="rat", not IsEmpty(subcategory),IsEmpty(subcategory))

Dj

Thank you! Thank you!