Product
Support
Everything Else
Delete Duplicate Records

To delete duplicate records, create the Abacus shown here:

Attach the Abacus as an Abacus Query under Show Selection. If an Abacus Query is already attached, modify it to include the above Duplicate Suppression Query. With this Abacus attached, only duplicate records will display.

Build an Index on the Field or Abacus that is the condition for the supression (if one has not been built already). Attach it to your listing form under Show Selection. When the list displays, execute Delete All from the View menu to delete the duplicate records.

Note: If you have not validated to prevent the creation of duplicate records, you can add this listing form to a network administrator's menu to allow him or her to perform such deletions while the Collection is being served to a workgroup.