Which table is selected, table1 or table2?

The FOR is scoped to the table in the current work area

Make sure you selec table2 first.

>I am trying to replace fields from one table to another. >
>It works for one record but the other 2 where the condition "table1.field5 = table2.field5 AND table1.field6 = table2.field6" is true are not being updated. Thanks in advance.