Kevinb, why not just use Select ... Into Cursor ... ReadWrite
Then you can replace the fields' values.
And finally append the cursor's records to your table.
>I want to SCATTER a record from one table, add some
>fields to the record object, then GATHER into another table.
>
>Both tables have the same structure, with the exception of 4 extra
>fields on table 2.
>
>To accomplish this, I SELECT out the record, plus the extra fields, then
>SCATTER to the record object. Is there a different way to do this?
>
>
>SELECT Table1
>nRec = RECNO()
>
>SELECT *, DATETIME() AS Field1, SPACE(11) AS Field1,;
> SPACE(1) AS Field3, SPACE(2) AS Field4;
> FROM Table1;
> WHERE RECNO() = nRec;
> INTO CURSOR Temp1
>
>SCATTER NAME oRecord MEMO
>
>oRecord.Field1 = DATETIME()
>oRecord.Field2 = "Some Value"
>oRecord.Field3 = "A"
>oRecord.Field4 = "01"
>
>SELECT Table2 APPEND BLANK
>GATHER NAME oRecord MEMO
>