AnsweredAssumed Answered

Checking calculation result is a unique number...how?

Question asked by LightningAd on Jan 30, 2009
Latest reply on Feb 6, 2009 by LightningAd

Title

Checking calculation result is a unique number...how?

Post

I have a calculation that creates an alphanumeric code number from various elements. I need to include something into the calculation to ensure it checks the result is a unique number, and forces the user to re-enter using new elements....

problem is i don't know how to do it.

 

The calculation currently in use is "agency code &  "/" & product code & Right( "000" & serial; 3) & "/" & duration".

 

Please can anyone tell me how i can add something to check its uniqueness?

 

thanks

Adam 

Outcomes