>>>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.
Yes, thanks for catching it.
SET ORDER TO IN TABLE1
SELECT table2
SET RELATION TO RECNO() INTO table1
REPLACE ALL table2.field1 WITH table1.field1
--sb--