3 Replies Latest reply on Dec 18, 2013 4:49 PM by philmodjunk

    Checking a PIN's uniqueness

    MichelePatricola

      Title

      Checking a PIN's uniqueness

      Post

           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.