I have a question about using insert into. I have one table that I want to add records to from another. I use the code
SCATTER MEMVAR MEMO
INSERT INTO NEWTABLENAME FROM MEMVAR

Some of the fields are not getting updated. The fieldname, type, and sizes are the same in both tables. The order of the fields are not. Each table also has other fields. Why aren't all the fields getting updated?

TIA