Relationship Dialog - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Help
Smart Instrumentation Version
13.1

To access this dialog right click on the Relationship DB Icon 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.