To open the 'Database Setup' window, choose Database Setup from the Tools menu. The main part of this window is occupied by a tab control with two tabs: Tables and Fields.

The list on the Tables tab gives you an overview of all tables in the database.

This list has three columns. The first column displays the default table name, the second column the active table name, and the last column indicates whether the table is in use or not.

You can change the sort order by clicking the heading of one of the columns. The properties list to the right displays the properties of the selected table. Context sensitive help is available for each property.

To edit the fields in the selected table, click the Fields tab.

The list on the Fields tab gives you an overview of all fields in the selected table. This list has four columns. The first column displays the default field name, the second column the active field name, the third column the field group, and the last column indicates whether the field is in use or not.

You can change the sort order by clicking the heading of one of the columns. The properties list to the right displays the properties of the selected field. Context sensitive help is available for each property.

When you want to modify a field, it is important that you select the correct table before you activate the Fields tab. For example, to modify the Country field in the Stamp table, first select the Stamp table on the Tables tab, then click the Fields tab to display the fields in the Stamp table and locate the Country field.

You can save the database setup as a database template. This template can then be used when creating a new database. This is useful if you want to share the database setup with others.

Do you have question? E-mail us at support@fnprg.com.