PROBLEM

An invalid attributed relationship class is created when the foreign key names are the same

Last Published: May 20, 2020

Description

Specifying the foreign key fields in the relationship table to create a many-to-many or attributed relationship class in a personal geodatabase results in an invalid attributed relationship class. On an SDE, the creation of such a relationship class yields an error.

Cause

The origin and destination foreign key fields in the relationship table have the same field name.

Solution or Workaround

Assign unique names to the origin and destination foreign key fields in the relationship table.

Article ID: 000004481

Software:
  • ArcMap 8 x
  • ArcMap 9 x

Get support with AI

Resolve your issue quickly with the Esri Support AI Chatbot.

Start chatting now

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Start chatting now

Go to download options