Field Validation, doesn't
I have noticed that field validation on seems to work on commiting a record or forcing the entry of the record. I have not seen this before although I thought that validation occured when you modified a field or left the field. Using FMP12, am I am doing something wrong?
My validations of a date field was to assure that the date was not a Sunday.
Validation by calcualtion = If(DayOfWeek(Date_field) = 1, 0, 1) // Sunday=1
This works, but not on field exit or tabbing to next field. It works when total record is entered.
Am I missing an option to validate?