Now you need to define the relationship between the items
-
Right-click
, the Relation dialog box opens. The Relation field should be displaying Instrument - Loop.
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. In addition,
you can see the relationships in the Query Preview.
-
From the Method group box, make sure that the method, Display only X [Item Type] records and Y [Item Type] records that are related is selected. This ensures that only those rows where each side of the relationship has data are displayed.
-
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.
-
-
Click Close.
-
Now add to the Definitions window two more Item Types that are related to the instrument using the following relationships and method.
Item Type
Relation
Method
Line
Instrument - Line
Display only X [Item Type] records and Y [Item Type] records that are related
Document
Instrument - Spec (All cases)
Display only X [Item Type] records and Y [Item Type] records that are related
The Definition window should look something like this.
Drag and place the items in the Definition window to display as above, or click on the 
, from the toolbar.
The Relation dialog boxes should look like this:
