Hi José,

I think that the only way to check for changes in table2 is to have a copy of that table made on last update of table1. This way, everytime you want to update table1 with table2, you first go and check table2 and table2_copy; if changes appear, then update table1 with those changes.
When comparing table2 and table2_copy you will have to do it by the primary key. If you try to compare them on recno() then you can get fooled by deleted records.

Hope it gives you a starting point.
Regards,
Javier.

>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,