Here is a bit of code I cobbled up to delete duplicates.
Help yourself or correct my errors if there are any

SELECT [Your table name here]
COUNT TO EndOfTheFile
? EndOfTheFile
? " Searching for duplicate records"
FOR Outside = 1 TO EndOfTheFile
	GOTO Outside
	GoodRecord = ALLTRIM(Field name here)
	FOR Inside = (Outside + 1) TO EndOfTheFile
		GOTO Inside
		CheckedRecord = ALLTRIM(Field name here)
		IF CheckedRecord = GoodRecord
			DELETE
		ELSE
			DUMMY = DUMMY + 1
		ENDIF
	NEXT Inside
NEXT Outside
* BROWSE
* PACK
CLOSE TABLES