When a layer participates in a relate or relationship class, you can access the related data in the upper portion of the pop-up where the identified items are listed. You can also use the Configure Pop-ups pane to add fields or statistical functions to the attributes portion of the pop-up based on the related data. Add a Related Records element to preview the attributes of up to ten related records. For text elements in the pop-up, you can choose a field from a related table from the Fields drop-down menu. For the fields element, the related data is appended below the main list of fields. The name of the relate precedes the list of related data. For chart elements, you can choose from numeric fields in the related table to add to your chart. Numeric field formatting for decimal places is honored by the pop-up.
Relationship classes must have a cardinality of 1:1, 1:M, or M:N to be used in a pop-up.
Preview related record attributes
Preview up to 10 related records of either a relate or relationship class. Sort the related records to control which records are presented. For example, you can preview the 10 most recent fire hydrant inspection results.
Include a related records element using the following steps:
- Right-click the layer in the Contents pane and click Configure Pop-ups
.
- Click the Related Records button
to add it to the bottom of the current configuration.
- Click the Edit pop-up element button
for Related Records element.
- Click the Relate or relationship class drop-down menu and click the related data to be previewed.
- Optionally, under Sort related data by select a field and sort direction to control the order the related data is previewed.
By default the first numeric field is sorted in ascending order.
- Optionally, under Preview Count, use the arrows or type the number of related records to preview.
The default is 1 and the maximum is 10.
- Click Back
to close Related Records Options and save your changes.
The main page in the Configure Pop-ups pane appears.
Note:
If you display a pop-up for a feature that does not have any related records, a message appears in the element indicating that none were found.
Include related record values in a Fields element
For 1:1 relationships, values from the related table are displayed from the singular related record. For example, for a 1:1 relate between a layer named Offices and a table named Current Staff, the pop-up can display the office identifier from the first table and the current occupant's name and hire date from the second table.
Include the related values for a 1:1 relationship using the following steps:
- Right-click the layer in the Contents pane and click Configure Pop-ups
.
- Click the Edit pop-up element button
for a Fields element.
- In the Related Records: Statistics section, expand the related table name you want to use to include field values.
All fields from that table are listed.
- Check the Display check box for the fields to include.
- Click Back
to close Fields Options and save your changes.
The main page in the Configure Pop-ups pane appears.
Include related record statistics in a Fields element
For 1:M and M:N relationships, statistical summary values are collated from the potentially multiple related records. For example, for a 1:M relate between a Land Records layer and a Previous Owners table, the pop-up can display the parcel address from the first table and the count of previous owners and maximum purchase price from the second table.
Include statistics for the related numeric fields in the pop-up using the following steps:
- Right-click the layer in the Contents pane and click Configure Pop-ups
.
- Click the Edit pop-up element button
for a Fields element.
- In the Related Records: Statistics section, expand the related table name you want to use to include statistics.
All numeric fields from that table are listed.
- Check the Display check box for the fields to include.
A new row containing the applicable statistics appears below the chosen field name.
- Choose related statistics to add to the pop-up.
- Click Back
to close Fields Options and save your changes.
The main page in the Configure Pop-ups pane appears. If no related statistic was chosen in step 5, the related field is automatically unchecked when you save your changes.