Skip To Content

Managing related tables

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

To use this feature, the related table must be published via the same feature service as the event feature classes that are used in the Event Editor application. If publishing a view-only Event Editor instance, the table must be published as part of the same map service as the event feature classes. 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 way event feature classes do. 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 relates between two layers created in ArcGIS Desktop.

Note:

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. Editing the key field value of either the primary key (event feature class) or the foreign key (related table) will impact the existing relationship between the features of each of the related objects. Event Editor will provide warnings when any value in the key field is edited. The foreign key field of a related table will appear with a green column header.

  1. 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.

  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.

    The related table widget appears.

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

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

  4. After edits are complete, move focus off the related table widget.

    Any changes that have been made but not saved are highlighted in yellow.

  5. Click Save on the related table widget to commit these 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 table widget appears with a new editable, unsaved row added to the related table and a foreign key value populated for you.

  3. Click any cell to add new values for the new record.
  4. Click Save on the related table widget to commit these edits, or close the widget to discard them.

For more information on relationship classes, see Relationship class properties.