Lakota Posted April 27, 2004 Posted April 27, 2004 Howdy all: I am trying to get filemaker to validate a set of fields: Reason1 Reason2 If reason1 is empty, then reason 2 should have something in it, but both can not be empty when the user exits the record entry. Any thoughts on that? Thanks in advance for your help. Lakota2k
-Queue- Posted April 27, 2004 Posted April 27, 2004 Validate both fields with IsEmpty(Reason1) xor IsEmpty(Reason2), meaning either field, but not both, can be empty. Deselect 'Validate only if field has been modified' for both. Note that this will fail if both fields have data. If that is an option, then use not (IsEmpty(Reason1) and IsEmpty(Reason2)).
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now