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

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.