Related Records

Related Records are a way to establish a feature-to-table or feature-to-table-to-table relationship and provide additional information in the Designer XI application. These records are available as view-only at this time. Examples include inspections, service address, and customer data. These relationships can be created by your administrator for tables that exist in the network feature service and can be configured for electric and gas domains in either UN or GN implementations.

The display field, other fields to show, and display order are configured in the Solution Center Designer plugin when the related relationship is established.

If a component has configured Related Records, a new tab is shown in the Component Information pane. The record and fields are pulled on the fly as the designer selects a component and clicks on the Related Records tab. The number of records is shown in parentheses after the Display Field. Use the tree navigation to drill down into the detail. Clicking on a node opens detail fields in the grid below. If there are no Related Records for a component, the Related Records tab does not display.

Here is a feature-to-table example where the feature Pole has a configured relationship to the Pole Inspection table.

In the next example, notice the feature-to-table-to-table relationship. Here the Service Point feature is related to a Service Address table, which is related to a Customer Info table. The detail grid displays the fields for the lowest-level node selected in the Related Records tree.