>Hi Chuck,
>
>The UI is only useful in a few instances. We use it to eliminate dupes and as a "cheap" way out of queries when we want to find what values may have been used.
>
>FoxTalk May '97 has an article - A "UNIQUE" Approach to De-duping in FoxPro.

You can use this instead:

use table1 in 0
use table1 again in 0 order primary1 alias target
select table1
set relation to primary_expr into target
delete for recno() != recno("target")