If you want to export a routine set of fields, you can create a script that uses the Export Records script step. Store the desired fields and order there.
Fields that are in form view take precedence over the table view.
If you rearrange them in table view, the order will still be form view first.
The order in table view ( the display order ) is stored with the view and can be reset with right-click dropdown menu.
It looks like when there are no fields in form view, the table view field order is as you add them from top down.
Rearranging them later has no effect in Export Records dialog.
Selecting table view in the Export Records will give you the order that is chosen set in Manage Database window.
My best bet would be to first arrange fields in form view then use that layout in table view.
Instead of File > Export Records, use File > Save/Send Records As > Excel. This doesn't ask which columns should be included, and the output file seems to reproduce the information as shown in the Table View.
yes! that is one of the features I rely upon. Table view column order is what gets sent to Excel with the Save As (Excel)