One of the solutions could be like this:

use table2
use table1 in 0 order key_field
set rela to key_field into table1
scan for eof("table1")
scatter memvar
insert into Table1 from memvar
endscan


>Hi,
>
>I would like two compare the contents of two dbf tables. I would like to update table1 with the contents of certain fields in table2, if an new record exists within table2.
>
>I don't know how to begin, any suggestions are appreciated.
>
>Thank you,