Deduplicate?

[David Thompson]

>Hello,
>
>I have a list sorted so that the duplicate records in my DB are shown
>(sorted up). What I'd like to do now is remove all but one of each
>duplicate record (sometimes there are two duplicates, sometimes there
>are three). The field I'm using to identify the duplicates is Orgname.
>
>Does anyone know of a procedure for this?

The Unpropagate command can be a big help with this. If you make your 
Orgname field the active field and do an Unpropagate, then whenever a 
value matches the one in the preceding record it will be changed to a 
blank, so then you can select just the records that have a value in 
that field and remove the rest.

Field Orgname
Unpropagate
Select Orgname <> ""
RemoveUnselected

Dave