Delete Duplicate Records based on one field

[danlapp]

I have a Foxpro file that contains records with some duplicate customer numbers. I want to delete duplicate records that have the same customer number, leaving only one unique record for each customer. I don't care which duplicate record are deleted or kept, as long as the resulting file has the same structure (data and index) as the original.

What commands in DBF Commander can process deleting the duplicates?
Do I have to be concerned about retaining the original file's structure (data and index), especially if a new file is created?

Thanks,
Dan L.

[Admin]

Dan,
please try to use Tools -> Delete Duplicates command.

[danlapp]

Thanks. Very useful.