Hello,
Typically there is no need to have a field in a specific location within a table. In more elaborate systems this may be a concern but not for average use. Still many prefer this for aesthetic reasons. You can do this with SQL. Add your new field to the end of the table. Then from the main Base screen under menu item Tools->SQL
you can run a statement to position the field where wanted. Here is the method:
Change Table Column Position
Syntax: ALTER TABLE tablename ALTER [COLUMN] colname POSITION
Example: ALTER TABLE salary_history2 ALTER old_salary POSITION 2
From Firebird documentation:
The POSITION keyword changes the position of an existing column in the notional “left-to-right” layout of the record.
Numbering of column positions starts at 1.
• If a position less than 1 is specified, an error message will be returned
• If a position number is greater than the number of columns in the table, its new position will be adjusted silently to match the number of columns.