AnsweredAssumed Answered

Checking a PIN's uniqueness

Question asked by MichelePatricola on Dec 18, 2013
Latest reply on Dec 18, 2013 by philmodjunk


Checking a PIN's uniqueness


     Hi, I am trying to create unique PINs for specific "people" in my work's database. I have managed to create a field that will generate four random integers when certain name fields are populated. When a new PIN is generated, I want to make sure it is not already in use by another "person" (name field). I know the odds of a repeating random number is slim but I  just want to be sure. I know basic coding but I'm not proficient in the subject. I would greatly appreciate anyone's help.