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"


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

  • ArcMap 8 x
  • ArcMap 9 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic