Add row to table and form

In my first attempt at a db I made a long checklist that needs to be competed in order. I made a table with the fields and then made a form, I think. After extensively editing the form I notice one of the fields/controls is missing. I tried to add it in the table, but it won’t add a row in the middle it puts it at the end. Now when I open the form this new added field is not shown even thought I added it to the table. How can you add fields/controls in the middle of tables/forms while keeping everything in order and properly numbered?

Adding a row in a table: It depends on the driver for the database to get the right position.
Internal HSQLDB:

ALTER TABLE "tbl_persons" ADD "forename" VARCHAR(25) BEFORE "surname";

To position a new row is possible. To position a row after it has been created isn’t possible.
Internal FIREBIRD:

ALTER TABLE "tbl_persons" ADD "forename" VARCHAR(25);
ALTER TABLE "tbl_persons" ALTER "forename" POSITION 2;

Only existing fields could be positioned. So first the field has been created and next step is to get it positioned by a number. “forename” will be the second field after it has been positioned this way.

In forms you could position fields where you want. If you try this with a table control: Right mouse click on a field in this control and add the new field. It will be available at this position now.