>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
arraySELECT
newtableAPPEND FROM ARRAY
array FIELDS
fielda, fieldb, fieldcHTH
Matt McDonnell
...building a better mousetrap with moldy cheese...