PROBLEM

Relate is unavailable in the Options > Related Tables context menu

Last Published: April 25, 2020

Description

Relate is unavailable in the Options > Related Tables context menu.

Cause

No objectID type column exists in one or both tables. A table without an objectID must contain a unique, not null, indexed field to fully participate in relates and support selections. ArcGIS recognizes any numeric field that meets these criteria as type objectID and enables relates and selections.

Solution or Workaround

Create a new field using the following steps:

  1. Use the native software to add a long integer field to the table. If one of the data sources is a Microsoft Access table, the field must be the AutoNumber data type and defined as a primary key.
  2. Use the native software to create a unique, non-null index on the long integer field just created.

Article ID:000004856

Software:
  • ArcMap 9 x
  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic