sotura

Unique Values and Null Values FM15

Discussion created by sotura on Jul 25, 2016
Latest reply on Jul 27, 2016 by sotura

I have a table that I am running and it populates itself with bar code values that are either entered in or scanned in and they need to be unique number codes. The problem I'm encountering is during filemaker validation if I attempt to duplicate the record and or create a new record with a bar code value of " " (nothing) it will throw a validation error because Null is not considered a unique value. Is there a way to stop this error from happening with no value in the bar code slot?

Outcomes