NO duplicate files
I am making a database to have information for our participants and wanted to include i.d numbers for each member of the family. I want to have an error message come up if there's a duplicate number both within the record and within the database.
Is this something that can be done? I have these options marked off on each "index, unique, allow override".