Hello.

I need help to set up a function or something similar, that would work as a "unique identifier" for a field.

The "unique identifier" shall only let me know of a unique value if there are more than 3 caracters in the field.

What I am looking for is almost the same as the built in "Unique value" function that is under the "Validation" tab.

But if I choose that function, it will validate all of my input in my field.

I.E. I got a field called "Dep_number" wich I can input numbers up to eight characters.

I usually input two or eight chatacer numbers in this field.

I don't want it to validate my two character inputs as unique, but I want in to validate every input with 3 or more characters in it.

Does this make any sence???

You might be able to use a validation by calculation and a self join to get what you want.

Case ( Length ( Dep_Num )>2;

       Case ( Count ( SelfJoin::Dep_Num )>0 ; 0; 1 );

       1

     )

Hi caman

try this one :

UniqueByCalc.zip

:thumbup:

Thank you.

This is what I'm looking for!

caman