You can use a query to compare the records that do not exist in one table and copy it to another
[code]select * from tableA
where not exists (select * from tableB code]
or you can set a flag in the table 1 or 0 when a new records is added and only copy those records. when you copy the records reset the flag.
set updated = 0
where not exists (select B.customerid from tableB as B where B.customerid=TableA.customerid)
Jaime E. Maccou