ERROR

Join cannot be based on a 1-many relationship class

Last Published: April 25, 2020

Error Message

Joining data to a table or layer through a relationship class returns:

"Join cannot be based on a 1-many relationship class"

Cause

You cannot create a join based on a one-to-many (1-M) relationship class from the one side.

Solution or Workaround



Create the join from the many side or, if the data is one-to-one (1-1), create a one-to-one relationship class.

Article ID: 000003693

Software:
  • ArcMap 8 x
  • ArcMap 9 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options