>I need to compare every field between two tables to determine if the records are duplicates of one another. CAn anyone assist me in this?


If you want to go record by record, you could select use the first table, SCATTER NAME oTable1
use the second table
SCATTER NAME oTable2
COMPOBJ(oTable1, oTable2)

But they have to be in the same order. There was a question like this a couple of months back, and someone had a way of comparing the 2 tables using SQL selects, but I can't remember how they did it. Good luck,
John