can't find duplication of data using the "!" operator
There is a field in filemaker I have made a unique field. When a duplicate of data is entered into that field a custom message popup saying the field is unique.
There is a particular data that when I enter into that field, it popup saying the field has to be unique but I'm not finding the duplicate data in any record using the "!" operator. Do you know why or can you help?