>I am trying to replace fields from one table to another. There are 3 records where the condition exists for replacement, however, only one replacement is being done. My table that is being written to has data buffering of 0. Here is the psudo-code:
>
>
>REPLACE table2.field1 WITH table1.field1, ;
>   table2.field2 WITH table1.field2, ;
>   table2.field3 WITH table1.field3 ;
>   FOR table1.field5 = table2.field5 AND ;
>       table1.field6 = table2.field6
>
>
>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.

Are these two tables related with SET RELATION and you're in TABLE1 while doing your replace?