English

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

Description

The foreign key fields in the relationship table must be specified to create a many-to-many or attributed relationship class. In a personal geodatabase, the same field name can be given to the origin and destination foreign key fields in the relationship table. This results in an invalid attributed relationship class. On SDE, the creation of such relationship class will yield an error.

Solution or Workaround

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