>Hey All,
>what is considered the best way to move multiple records from 1 table to another table with the same fields????

You might try something like

SELECT * FROM sourcetable WHERE conditions NOFILTER INTO CURSOR mycursor
SELECT destination
APPEND FROM (DBF('mycursor'))