Is there a quick way to test a database for a duplicate record?

Sample [mydata.dbf] check for duplicate in field [name]
i have a rather cumbersome way of checking and would like to know if there is a more efficient code.

thanks alot
k