AnsweredAssumed Answered

Checking calculation result is a unique

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


Checking calculation result is a unique


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?