In this document the methods are described for displaying fields from other BE tables related to the master table by defining related tables in the program 'Related Tables. Connect' (CMS011).
Open (CMS011) by using alternative 11='Related tables' in these programs:
In (CMS011), you can define up to 30 related tables.
To create a related table on the (CMS011/B) panel, specify the table.
Use alternative 1='Create'.
|Field||The field indicates ...|
|Sequence number||...the read sequence used for this related table compared to other related tables.|
...an index connected to the table.
An index is a unique sorting order of a table. The sorting is controlled by the selected fields and by their relation to each other.
System-defined indexes (00–99) or user-defined indexes (U1–U9, V1–V9, or X1–X9) can be used.
...how to set the key fields in the related table according to the selected 'Sorting' option.
|Trim zeros||...if leading zeros should be removed. The field is only used if the 'Master table' field is numeric and the 'Related table' field is a text string.|
You can also perform a quick entry to define a related table:
Use F8='Create New' for the button 'Create New' on (CMS011/B).
Specify the related table name and press OK.
If the 'Read' alternative between the related and master table can be determined automatically, (CMS011/N) is displayed.
On (CMS011/N), specify the field selection to select if all or only specific fields should be added to the 'Field' group. If specific fields should be selected, a maximum of 10 fields can be selected simultaneously.
If the 'Read' options cannot be determined automatically, (CMS011/E) is displayed.
Press Enter to activate the related table and update the 'Field' group with selected fields.
If additional fields should be added, use alternative 7='Add field to field group'.
The fields from the related table can now be selected as fields (columns) in the view.