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.