I was trying to do it more SQL-ish; is that possible? I thought using APPEND would lock the table header and make it less multiuser.


>
>It can't be done in one insert-sql in VFP; however, here's one quick way I've used before

>use smalltable order candkey
>append from bigtable ;
>     for !indexseek(candkey, .f., "smalltable", "candkey")