Letters and numbers. p1=Unique and 1=Unique

[Tudor]

I have a problem in getting validation separate letter+number "p1" and number only "1" as Unique value.

If I define the (number) field as Unique value I get a message that the number is in use if I enter letter +existing numbervalue.

If I define the (text) field as Unique value I have no problem entering Unique values ... but then when I use sort or find...

Need to have numbers as sorting and text when entering. How do I do that.

Or how do I calculate the Unique value upon entering data.

Peter Norling Sweden

Ps. The numbers entered are starting numbers for dragracing and Cars have number (1078) and Bikes have Letters + Numbers (Mc1078)

[PeterHW]

Hi,

For number fields, the validation will ignore any non-numeric characters, so 1000 and MC1000 are the same.

In text fields, all characters are evaluated, and 1000 and MC1000 will not be regarded as equal.

So make your field a text field. For sorting, create another calculation field, result number GetAsNumber(UniqueField) and sort on that.

Regards,

Peter

[Tudor]

Thank's I will try that

Peter Norling