Database Fields page

The Database Fields pages enables the fields of a database to be created or renamed and their order to be modified.

For a new database fields may be created  by
either
(i) entering the number of fields required and pushing the Create button (which will create the fields with default names - Field0, Field1, etc.)
or
(ii) entering the field names one at a time into the New Fieldname box and pushing the Add to List button after each one.
Then push the OK button

Existing fields may be renamed by selecting the name in the field name list and then modifying the text in the New field name box, and finally pushing the Rename button.

Field names exist only for the user’s convenience. Data extracted from the database is obtained using the position of the field name in the field list. Thus data from the first field is always obtained from the first field no matter what the field is called.

Field names may also be re-ordered by selecting a name from the field name list, then pushing the Move button, and then dragging the selected item to the new position you wish it to occupy.

Note that re-ordering the field names re-orders only the names - not the data in the database. Thus the first field in the list will always contain the data at the start of a record no matter how many times you re-order the field names.

More:

Database Open page