>Hi Deamon
>
>You should put ALL after REPLACE:
>
>REPLACE table2.field1 WITH table1.field1, ;
> table2.field2 WITH table1.field2, ;
> table2.field3 WITH table1.field3 ALL;
> FOR table1.field5 = table2.field5 AND ;
> table1.field6 = table2.field6
>
>Cause by default, REPLACE only change the next one!
>
>Hope this help! :)

As Nadya points out this in not the case. In fact, for every FoxPro command where applicable, the conditional ('FOR') makes the default scope ALL. So REPLACE ... FOR ... is the same as REPLACE ALL ... FOR ...