Hi Nick,

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.

select lv_veh
scatter name oFields
select vehicle_arc
append blank   && your new record should get the uniqueID
gather name oFields

HTH

>Thanks for answering. I was trying the following. The table that this data is going into generates a uniqueid in one of those extra fields I mentioned (a nextid.prg in the table stuctures default values).
>
>

>select vehicle_arc
>SELECT * from lv_veh WHERE lv_veh.v_id = .a INTO TABLE vehicle_arc
>TABLEUPDATE(.t.,.t.,'vehicle_arc')
>

>
< snip >
>It is almost as if the INTO command is trying to create a new table. I want it to go to existing table. The Scatter, Gather command won't automatically create the uniqueid, guess it doesn't work unless I do somekind of SQL command. I works when I do INSERT.
>