Thereforeâ„¢ Help

See Also

 

Referenced Tables allow a category's or case definition's index fields to reference data in an external database. This provides a convenient way to link an index field to a database table from another system. Typically, this is done by setting up a view of the external database within the Thereforeâ„¢ database.

 

The table needs to be in the Thereforeâ„¢ database. Typically this is done by creating a view on the external database. Or, for Thereforeâ„¢ Online systems where the Thereforeâ„¢ server cannot access the external database, using Table Replication.

 

Right-clicking on the Referenced Tables object opens its context menu.

 

New Referenced Table...

Opens a dialog for creating a new referenced table (see Creating a new referenced table).

 

New Folder...

Create a folder (sub folder) to help organize referenced tables.

 

Export...

Export the configuration definition.

 

Security Report...

The security report contains all security settings. It allows you to document the final security configuration after installing a system. The security report is stored as a ".csv" file.

 

Security...

This displays the security dialog.

 

Right-clicking on a particular referenced table opens up a different context menu.

 

 

Open Referenced Table

Opens the Referenced Table dialog. A name for the referenced table must be specified, the table or view must be chosen and the column must be specified. This column will be the unique identifier for all dependent fields based on this referenced table.

Delete Referenced Table

Deletes the selected referenced table.

 

 

 

Export...

Export the configuration definitions for the selected referenced table.

 

Security...

This displays the security dialog for the selected referenced table.