>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.
--sb--