>If I use an append from, will the extra field in table2 cause a problem?, since the extra field has a default value that generates unique id (nextid.prg), append from doesn't seem to fire this default value, only insert into.
If you have to use INSERT INTO then:
select table2
scan
scatter memvar memo
insert into table1 from memvar
endscan
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao