>When you 'scatter field' from one table and then 'append' to another table, does the order of the field name from both tables matter??
>
>
>select temp
>
>scatter field like lastname, firstname to array
>select table
>append blank
>gather from array
>
>if I have the field name revert (firstname come first) in 'table' does it screw up the lastname and the firstname??

If you scatter to/gather from array, the order does matter.

But don't use gather anyway...and don't use field skeletons either.

Try something like this...

SCATTER FIELDS field2, field1, field4 TO array
SELECT newtable
APPEND FROM ARRAY array FIELDS fielda, fieldb, fieldc

HTH