field order on import or table copy gets rearranged
I am importing records from one file to another. In the source file I have a custom, non-alphabetic import order.
In the target file, it accepts the order I have in the source file, but when it imports, it resorts the field order to alphabetical (e.g under the manage database:fields view and when creating a new template). I an 'fix' this for the template by copying the source file template over, but cannot for the field order in the manage database view.
Is there a way around this?