Nick,

Personally, I would still use SCATTER NAME, and move the memo fields separately. See below...

>Unfortunately, I do have memo fields. Can an array hold memo values? If so, I guess I can always do select into array and then insert fields into the second table.
>
>>
>>You are correct. SELECT ... INTO TABLE creates a new table.
>>
>>Are there any memo fields involved? You can use a SCATTER/GATHER NAME approach to get the non-memo fields.
>>

local oFields, lcMemo1, lcMemo2

select lv_veh
scatter name oFields
lcMemo1 = lv_veh.memoField1
lcMemo2 = lv_veh.memoField2
select vehicle_arc
append blank   && your new record should get the uniqueID
gather name oFields
replace memoField1 with lcMemo1
replace memoField2 with lcMemo2

>>
>>HTH
>>