To access this dialog right click on the Relation icon in the Definition window. You use the Relationship dialog to select the relationship type and method between the chosen attributes
Relationship Type
From the list select the required relationship. Certain relationships have only one choice available, for example Instrument to Loop, others have many, for example Instrument to Panel displays a list with all the different panels that can be related to an instrument, Junction Box, Device panel, Marshaling Rack, and so forth. To see in the EDE view those instruments with junction boxes for example, you would select the relationship Instrument - Junction Boxes.
Method
To select the relationship method, select on the appropriate method and then select Close, or select outside of the dialog, to close the dialog. There are three methods to choose from:
-
Display only X [Item Type] records and Y [Item Type] records that are related — Displays all the rows where each side of the relationship has data.
-
Display all X [Item Type] records and only those Y[Item Type] records that are related — Displays all the records from row item type X even if there is no relationship to row type Y, but only displays related records from row Y.
-
Display all Y [Item Type] records and only those X [Item Type] records that are related — Displays all the records from row Y even if there is no relationship to row X, but only displays related records from row X.
-
Selecting the correct relationship method is an important factor in your query returning the correct information. Therefore it is recommended that if you are uncertain as to which method to choose, select Display only X [Item Type] records and Y [Item Type] records that are related.
-
When working with complex queries (three or more item types), it is recommended to use the same relationship method for the entire query.