>>Hi all,
>>
>>I'm trying to copy one field in table1 into the same field in table2, rec1 to rec1; rec2 to rec2, etc. The tables have the same records in the same order. Table2 has many more fields than table1.
>>
>>I know this is a sort of simple thing, but my mind doesn't want to get into gear today.
>>
>>TIA,
>>Pete
>
>Assuming that thare're no deleted records in either table.
SET ORDER TO IN TABLE1
>SELECT table2
>SET ORDER ON RECNO() INTO table1
>REPLACE ALL table2.field1 WITH table1.field1
Make sure to test it on the copy of your data.
Shouldn't the third line be a SET RELATION?
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)