Check out Sql Insert Into. It is easy to set up a control.
do while not eof()
insert into table2(field1, field2, field3, field4);
value(table1.field1, table1.field2, table1.field3, table1.field4)
enddo
Note,
Please don't foget the the colon or the commas.
Hope this helps
R D
>Hey All,
>what is considered the best way to move multiple records from 1 table to another table with the same fields????