There certainly would be a way to do what you describe but it would be helpful to know your reasons for doing this as it would likely affect the method or even redirect to an entirely different solution to solve the actual problem.
You can specify unique values on the name field. On the other hand value lists based on a field automatically omit duplicates.
Other useful facts:
if you specify unique values and validate always, you can import data into the table and duplicates are omitted during import.
Import records with the match found set option can be set up so that only unique names add a new record.
In similar fashion a self join on a name field can be set up such that only new names create a new record.