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')

The problem is that I get the following error:

File e:\fleet\vehicle_arc.dbf aready exist as part of a database

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.

Thanks
Nick Patel

>Hi Nick
>
>How about using Scatter to Array to copy the source record details and then Gather from Array to write the record into the destination table?
>
>HTH
>
>Jos