I'm looking for a solution that would prevent a user from duplicating a value in a certain field if this value is already present in the field. For example, if "PI2014313" is already present in this particular field, this value could not be entered in again in the same field.
I am aware of different tools that check for duplicates as well as field calculator and definition query scripts that can be used to check for duplicates, however I'm looking for a workflow that would automatically prevent duplicates from being entered in or makes the user aware that this value is a duplicate.
Any assistance would be greatly appreciated! Thanks in advanced!