>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

Yes, this is fairly easy with SELECT - SQL. For example:

select name, count(*) as count;
  from mydata;
  group by name;
  having count > 1

GROUP BY will create a single record for each [name] in this case; count(*) counts the records in each group; HAVING will evaluate the condition after the records are grouped.