AnsweredAssumed Answered

Bypass Unique Value Validation

Question asked by SteveKeiser on Oct 10, 2017
Latest reply on Oct 10, 2017 by philmodjunk

I found an record duplicated that I thought could not be done. The field validation is set to validate only during data entry, must be unique value, and to display a custom message. When the user uses a number in this field that is not unique, they get a dialog that tells them the number is already in use. The dialog has two buttons "OK" and "Revert Field". If they select "Revert Field" the field remains unchanged and they can go on and finish the record. How can I fix this so the user cannot get around the field validation? I have noted this behavior on FMP16 with MacOS.

Outcomes