AnsweredAssumed Answered

Unable to turn off field validation

Question asked by mprand on Jun 3, 2014
Latest reply on Jun 10, 2014 by philmodjunk

Summary

Unable to turn off field validation

Product

FileMaker Pro

Version

12

Operating system version

MacOS 10.7.5

Description of the issue

I had a field being validated by calculation and not empty/unique - calc= first 6 digits of the project number must equal the company id.  I first tried to add in the ability to override, but it did not work...still forced to revert. (Override worked in FM11). I also tried removing the calculation so it was just validating on unique and not empty as there are now some situations where the company id and the beginning of the project number may not match. I also changed the custom message.  the behavior was exactly the same as previous, along with the old custom message.  I've now turned off the validation altogether and the behavior continues to be the same as the original set-up.  What am I missing?

Steps to reproduce the problem

project set up screen
1- enter company id - pops in details of that company from the customer table or if new company, enter new custom details
2- enter project number and other details of the project
3- commit the record
4- if first 6 digits of the project number do not match the company id, then a validation error box pops up with a customer message and the user is forced to revert
(this continues to happen no matter what changes I make to the validation options on the project number field.)

Expected result

At step 4, if first 6 digits of the project number do not match the company id, user should be able to override the validation rule

Actual result

See step 4 above

ValOptions_Project_number.png

Outcomes