Multi Table Definition

Settings that has been applied in each Multi Table mode can be stored as a 'Multi Table Definition'. Each settings definition can be reused in the same Multi Table mode or other Multi Table modes.

These definitions can only be stored in the primary database, but these definitions can be accessed from primary database as well as secondary database (if available).

There are 3 main groups of settings that will be saved in the Multi Table definition:

1. Selection settings

settings of the tab 'Selection':

selected tables
table order in tree view option
the visibility of empty tables option (if applicable)

2. Options settings

settings of the second tab 'Options':

table rows to be printed or exported option of each selected table

3. Layout settings

settings of the last tab 'Layout':

output sequence of the selected tables
whether a table will be printed on a new page option of each selected table (if applicable)

These groups will be used to distinct the definitions that will be loaded or saved in a Multi Table functionality. The matrix below shows the availability of each setting in the Multi Table functionalities.

Settings

Available in

Print

Export

Import

Template

1. Selection settings:

selected tables

CheckGreen

CheckGreen

CheckGreen

CheckGreen

table order tree view

CheckGreen

CheckGreen

CheckGreen

CheckGreen

visibility of empty tables

CheckGreen

CheckGreen

DeleteRed

CheckGreen

2. Options settings:

selective table rows

CheckGreen

CheckGreen

DeleteRed

DeleteRed

3. Layout settings:

output sequence

CheckGreen

CheckGreen

DeleteRed

CheckGreen

print on new page

CheckGreen

DeleteRed

DeleteRed

DeleteRed

If a setting is available, this means that this particular setting can be saved or loaded in the concerning Multi Table mode. Actually, this matrix represents the interchangeability of the settings between the various modes of Multi Table.

For example, definitions saved in Print mode can be loaded during the Import mode. But, only the first 2 settings of the Print mode will be loaded into the Import mode. These settings are 'selected tables' and ' table order tree view'.

To facilitate the users selecting a previous stored definition to load, different icons are introduced for the stored Multi Table definitions:

Prnsel Type 3 this definition is created in Multi Table Print or Export mode
Prnsel Type 2 this definition is created in Multi Table Create Template mode
Prnsel Type 1 this definition is created in Multi Table Import mode
Click to expand/collapseHow to save a Multi Table Definition

To save the settings that has been applied in a Multi Table mode, click on the 'Save Definition As' button in tab Layout (except for Import mode: in tab Selection). This will open the 'Save Multi Table Definition As' dialog.

Multi Table Definition Save

Enter a name for this definition in the 'Definition name:' field and click on the Save button to save the settings in the current project database.

Click to expand/collapseHow to load a Multi Table Definition

Previous stored Multi Table Definition can be reused to simplify the Multi Table process.

To select a stored definition, click on the 'Load definition' button in tab Selection. This will open the 'Open Multi Table Definition' dialog.

Multi Table Definition Load

The definitions listed in the dialog 'Open Multi Table Definition' can be filtered using the 'Definitions of type' box. The following types are available:

All Definition types

all stored Multi Table Definitions will be shown

Selection, Options and Layout settings

only Multi Table Definitions created in Multi Table Print or Export mode (Prnsel Type 3) are shown

Selection and Layout settings

only Multi Table Definitions created in Multi Table Template mode (Prnsel Type 2) are shown

Selection settings only

only Multi Table Definitions created in Multi Table Import mode (Prnsel Type 1) are shown

User can load definitions from the current (primary) project or from the secondary database (if available). To select the store location:

Click on the appropriate database button on the left side of the 'Open Multi Table Definition' dialog

or,

Select the database from the 'Look in:' box.

Enter the definition name in the 'Definition name:' box or just select a definition from the list and click on the Open button to load a previous stored definition.

If a stored definition has been loaded, the name of this definition will be shown in the title screen of the Multi Table window.


Last changed: 14/09/2016