Use related data in pop-ups

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 lower section of the pop-up based on the related data. 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. 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.

Include related record values

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:

  1. Right-click the layer in the Contents pane and click Configure Pop-ups Configure pop-ups.
  2. Click the Edit pop-up element button Edit Pop-up Element for a Fields element.
  3. 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.

  4. Check the Display check box for the fields to include.
  5. Click Back Back to close Fields Options and save your changes.

    The main page in the Configure Pop-ups pane appears.

Include related record statistics

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:

  1. Right-click the layer in the Contents pane and click Configure Pop-ups Configure pop-ups.
  2. Click the Edit pop-up element button Edit Pop-up Element for a Fields element.
  3. 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.

  4. Check the Display check box for the fields to include.

    A new row containing the applicable statistics appears below the chosen field name.

  5. Choose related statistics to add to the pop-up.
  6. Click Back 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.

Related topics