Thanks Derk,
That's an acceptable solution...
>Maybe not the most elegant solution, but certainly one that would work
is
>
>select * from [your table] where [pick 1 record] into table [temporary
table]
>select [your table]
>append from [temporary table]
>
>this would copy and insert any selected records, including the general
field contents. I would prefer to use a cursor, but the help says you
need to append from either a file or an array, so you need to delete the
temp table afterwards.
(using VFP 3.0 for Win & Mac)