calculating unique ID

[Gabe]

is there a way to check to see if a calculated ID is unique within the calculation? Or do I have to bring it to the script level?

Is there a way to check the uniqueness of a value within the script other than going into find mode and searching for it?

[Wim Decorte]

if you create a self join relationship between the field that has the unique ID then a sum or count across the relationship will tell you if there are duplicates. You can use it in a calc or in a script.

[Gabe]

Thanks