Problem: Relate is unavailable in the Options > Related Tables context menu
Relate is unavailable in the Options > Related Tables context menu.
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:
- 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.
- Use the native software to create a unique, non-null index on the long integer field just created.