Perfect! Thanks


>>Is there a way to compare 2 tables with the same structure and identify the differences?
>

>select myTable1.* ;
>union
>select myTable2.* into cursor curPossDiff
>
>select ID, count(*) as Dups from curPossDiff group by ID having Dups > 1 ;
>into cursor curChangedIDs
>
>select * from curPossDiff cs LEFT JOIN myTable1 on cs.ID = myTable1.ID ;
>where myTable1.ID IS NULL into cursor curAddedRecords

>
>Easy to find deleted records too.
>

>select myTable1.ID from myTable LEFT JOIN myTable2 on myTable1.ID = myTable2.ID ;
>where myTable2.ID IS NULL into cursor curDeletedRecords