RELATE the tables & use a simple REPLACE

SELECT Table1  && That table contains Field4
SET RELATION TO Key INTO Table2 [ADDITIVE]
GO TOP
REPLACE ALL Field1 WITH Table2.Field1,;
            Field2 WITH Table2.Field2,;
            Field3 WITH Table2.Field3
SET RELATION OFF

>hi all,
>
>how i can replace field1,2,3 from mytable1(mytable1 have 3 fields only), to mytable2 field1,2,3 but keep field4 as it is,
>
>somthing as scatter memvar from table1 ,gather memvar to table2.
>
>thanks.
>m.qasem