Return to FileMaker.com
basic formula needed for Novice user
i am wanting a formula for a validation calculation so that if data is entered into a specific field (e.g. Field 1 which has a value list) then they must complete the next field (Field 2).
I was going to use a validation calculation when they tried to enter data into the subsequent field (Field 3) that tells them to go back and enter data into Field 2.
IsEmpty ( field1 ) or ( not isEmpty ( field 1 ) and Not IsEmpty ( Field 2 ) )
Retrieving data ...