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????