The Database Setup window

Previous pageReturn to chapter overviewNext page

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.

DBSetup_Tables

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.

DBSetup_Fields

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 Color field in the Asset table, first select the Asset table on the Tables tab, then click the Fields tab to display the fields in the Asset table and locate the Color 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.