Skip To Content

Managing related tables

You can view, edit, and add related table records in Event Editor. Tables included in a relationship class and tables related to event feature classes are accessible.

To use this feature, the related table must be published in the same map service as the event feature classes that are used in the Event Editor web app. In order to add records to the related table, the map service must have feature access enabled. If you want to view, but not edit the related table, you do not need to enable feature access in the service. Prior to publishing, it is recommended that you register the related table as versioned, and enable editor tracking if your event feature classes also use editor tracking.

Note:

  • Related tables in Event Editor do not support temporality the same way as event feature classes. While you can store date columns in a related table, it is important to note that related records will be related to event features by a primary key-to-foreign key relationship across all time.
  • It is not necessary to publish the relationship class. One-to-one, many-to-one, and one-to-many simple relationship classes between an event feature class and a table are supported, as are relationships between two layers created in ArcGIS Desktop.
  • Many-to-many attributed relationship classes and complex relationship classes are not supported in Event Editor. Messaging and relationship class rules are supported but must be administered using ArcGIS Desktop.

Viewing related records

You can view a related record as a reference to assist in event editing, such as viewing a maintenance date or an assignment.

  1. Select one event feature on the map or in the event attribute table.
  2. Click the Related Tables button Related Tables in the event attribute table.
Tip:

You can also use the Identify tool Identify and click the Related Tables button Related Tables.

Editing related records

An existing related record can be updated if you have write access to the related table. If the primary key (event feature class) or the foreign key (related table) field value is edited, the existing relationship between the features of each of the related objects will be impacted. Event Editor will provide warnings when any value in a key field is edited. The foreign key field of a related table will appear with a green column header.

  1. Open Event Editor and, if prompted, sign in to Portal for ArcGIS or ArcGIS Online.
  2. Click the Edit tab.
  3. Select one event feature on the map or in the event attribute table.

    The goal is to edit a record in another table that is related to a specific event feature.

  4. Click the Related Tables button Related Tables in the event attribute table.
    Tip:

    You can also use the Identify tool Identify and click the Related Tables button Related Tables.

    The Related Records widget appears.

  5. Double-click any cell in the widget to edit it.

    If the related table is published as part of the same feature service as the event layers, the cell will open for versioned editing. If the related table is not versioned, edits will occur in the default version.

  6. Review any unsaved changes indicated by cells that are yellow highlighted.
  7. Click Save on the related table widget to save the edits or close the widget to discard them.

Adding records to related tables

You can add records to a related table. If the cardinality of the relationship is one-to-one or many-to-one, Event Editor will provide a warning if more than one related record is being added to a particular event feature.

Note:

The option to add related records is unavailable if the related table is published as part of a map service without feature access.

  1. Select one event feature on the map or in the event attribute table.

    The goal is to add a record to another table that is related to a specific event feature.

  2. Click the Add Related Record button Add Related Record in the event attribute table.
    Tip:

    You can also use the Identify tool Identify and click the Add Related Record button Add Related Record.

    The Related Records widget appears with a new editable, unsaved record added as a row to the related table and a foreign key value populated for you.

  3. Click any cell to add new values to the new record.
  4. Click Save on the Related Records widget to save the new record, or close the widget to discard it.

Learn more about relationship classes and their properties

Learn more about editing events in the selection table