>I am looking for a good routine to find duplicate records in my tables. Most I have seen use one field that they can depend on to be unique. We all know in the real world there is no such thing unless you create it when you are adding the data and then still you can be adding a duplicate and giving it a unique key. Any ideas?

nFH = FOPEN( 'yourFile.DBF',11) will be -1 if the file is in use anywhere else. Note, you'll have to FLCOSE(nFH) the file before you can USE it.