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.
Peter Franz