>has anyone else experience SOMETIMES that when
>
>REPLACE TARGET.FIELD1 WITH SOURCE.FIELD1,;
> TARGET.FIELD3 WITH SOURCE.FIELD2,;
> TARGET.FIELD5 WITH SOURCE.FIELD3,;
> etc....
>
>is issued, the data will not save unless the target table is selected before the replace statement is issued?
>
>If so do you know why?
>
>Thanks a bunch.

Andy, add
IN myAlias (TARGET in your case) to your REPLACE

Nick