How to determine source of 507 error (Value in field failed calculation test of validation entry option)
I have isolated the field causing the 507 error on a new record request.
It's a Text field type with with options as Indexed/ Auto-enter Data. The auto enter value is 'N' and I'm trying to set it as 'Y'. Whey I view the properties in the layout on the Validation tab it says Validate data in this field `Only during data entry` and allow user to override during data entry. No other checkboxes are checked on the validation tab.
SO bottom line is it looks like there is no cause for for a validation error but yet that's the error coming back. Can you tell me how to figure out what's going on? Filemaker error messages are pretty generic - is it possible that another field (perhaps that depend on this field) is causing the issue and it is that field is not validating?
Thanks in advance,