Scan the first, seek the matching record in the second, then scatter both records to objects (Scatter name MyObjName). Then use CompObj to compare the two objects. If one field is different you'll get a FALSE return.
You'll also have to determine if there are records in the second table that are not in the first, but you can use SQL-Select for that
SELECT MyIDField from Table2 where MyIDField not in (Select MyIDField from Table1) into cursor curNotInTable1
HTH
Barbara
>I have two tables with identical structures and record counts. I need a quick way to extract the different rows from either table into a cursor or table. The differences might be a single field or more. Both tables have an integer PK and are in sync. Any thoughts? TIA