USE Master ORDER PrimaryKeyIndex IN 0 AGAIN ALIAS Master SELECT * FROM Dups ; ORDER BY TheExpressionThatYouWantToFindDupsOf ; INTO CURSOR Dups SELECT Dups SCAN * Check this record against the last record * If this is a dup * SEEK the Dups.PK in Master * Increment the Master table field ENDSCAN