Virtual Table Definition window: Fields

 


Virtual Table Name

Displays the name used to refer to the virtual table.

Display Name

Displays the name that appears when the name of the virtual table is displayed on the screen in an application.

Physical Name

Displays the name used when a view is created on a SQL server, based on the virtual table.

Series

Indicates the series for the virtual table. It’s a good idea to assign any reports you create to the same series that contains the report’s main table.

Record Size

Displays the size of each record in the data table, in bytes.

Tables tab

Tables

Displays the member tables of the virtual table.

Fields tab

Fields

Displays the member fields of the virtual table as well as the fields’ original tables, the storage types, and the storage sizes.

Relationships tab

Relationships

Displays how the member tables have been joined. The primary table is always added to the tree view first.

Secondary Table

Displays the table joined to the selected table in the Relationships tree view.

Relationship Key

Displays the key from the secondary table displayed in the Secondary Table drop-down list that is used to join the secondary table’s main table.

Index Segments

Displays the key from the secondary table.

Related Field

Displays the field from the main table that relates to a key in the secondary table.

Keys tab

Keys

Displays the member keys of the current virtual table. The keys available to add to the virtual table originate from the primary table.


Documentation Feedback