Data Type Mismatchright after the append blank. Does the names of the fields in destination table have to be identically to source table? The destination table is identical except the first two characters of the field names (destination) start with AV. Also the destination table has 3 extra fields, they are at they end of the table structure.
>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 >>>>