You can rearrange columns in a database table. This is useful when you need to have two or more columns visible together on screen. To move a column:
Click once on the bar above the table to select the whole column.
Click again but hold the mouse button down. A small rectangle is displayed.
Continue to hold down the mouse button and move the rectangle to the column immediately to the right of where you want the selected column to be positioned.
Release the mouse button and the table will be redrawn with the columns rearranged.
You can rearrange as many columns as you like.
Note: Ability allows you to rearrange columns as an aid to working efficiently with your tables. It does not, however, overwrite the field order you established when you first designed the table. Any rearrangement of the columns will be lost when you close the table and the original order will be reinstated. However, if you want to re-use a particular column rearrangement, you can create a Columns selection that can be applied to your table at any time.
See: