(Contents)(Previous)(Next)

Hierarchical Relationship Lists

Select the Relships / Hierarchy menu item to open a new window in which the selected object is created as the root of relationship displays. Starting from this root, several relationship lists on different hierarchical levels can be displayed in a window. In contrast to the other object lists, only the key columns of each object are displayed.

List boxes which display the selected relationships can be designed in the same way as for the direct display of relationship lists in form of object lists.

First, select the desired object by clicking on the relevant line in the list box using the left mouse button. You can then select an objct type by using the Relship / Object Usage menu function. A list box containing all the objects that are in a relation with the selected object will be displayed.

Pressing the right mouse button displays a drop-down menu with the same functions as provided under the Relships / Object Usage menu function.

In the following example, first, the root of the relationships hierarchy is created by selecting the Relship / Hierarchy function and an object from the View Object list:

Then the list of tables used by the view is created and displayed by using the Relship / Object Usage / Table function:

The relationship is represented by a line joining the basic object with the relationship list. The relationship name is displayed on this line within a frame. Arrows at the end of the line indicate the direction of the relationship (uses or used by ).

After selecting the lines of the second View List box and of the Relship / Object / Table function one after the other, more relationships can be displayed. The list boxes are moved and the frames of the relationship names are changed giving the following representation:

Options for the Selection or Display of Hierarchy Lists

Hierarchy options can be used to change the selection of relationship data and its representation on the screen. Select the View / Options menu function to display the following option select box:

1. Options for the Display of Lists and Relationships

The options are grouped in those relating to the current list box (Current List) and in those relating to any list box created later (Default).

- Show List Header: displays the bar with the object icon and type.

- Show List Title: displays the title bar of the list with the column names.

- List sizeable: allows the size of the list to be changed by using the mouse.

- Show Relship Names: (This option cannot be set for individual lists): displays the relationship names.

- Column Picture: displays the icon of the object type at the beginning of each list box line. Specify a value between 1 and 32 in the dialog box below the icon to set the size of the icon.

2. Options to Select Data from the Relationship List (Select Relship)

- Select All: displays all the objects in the relationship list.

- Select Own: displays all objects you own in the relationship list.

- Select Box: displays a dialog box in which the list to be created can be restricted by a search pattern.

- MaxLines: maximum number of lines displayed in a list box (1 <= MaxLines <= 999). If the number of objects found exceeds the specified value (MaxLines), a message is displayed. To restrict a result set, you can, e.g., use a Select Box.

Positioning and Sizing Lists and Relationship Names

Each new list box is placed to the right of the list box of the basic object. The list boxes and frames of relationship names can be moved in any direction within the window using the mouse. The column width and size of the list box can be changed (List sizeable).

After changing a list box (in size or position), the position of the relationship names is automatically adapted.

To change the size of the frame of a relationship name, double-click on the relationship name to set the frame to "sizeable"; then drag the frame at the size handles into the desired size using the mouse. To disable the sizing mode, double-click on the background of the window.

As soon as the relationship names have been changed in size or position, their position is no longer automatically adapted to the position of the list boxes.

Each list can be removed by using the Edit / Delete menu function. If Edit / Delete is activated for the last list in the window, the window is closed.

The View / SizeToFit menu function adapts the width of the list box to the current column widths.

All functions common for the object lists are available. In particular, it is possible to use the Relship / Hierarchy menu function to open another window for the display of relationship hierarchies.

All functions have an effect on the selected object or list box.


(Contents)(Previous)(Next)