Checking calculation result is a unique number...how?
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?