Repairing a layer in ArcMap does not restore joins and relates

Last Published: April 25, 2020


When repairing a layer with a broken link, joins and relates that were defined for that layer are not repaired.


Joins are not automatically repaired if the join table's workspace differs from the target layer's workspace. Relates are not repaired when the layer is repaired.

Solution or Workaround

There are two options for restoring joins and relates.

  • Save the map document using relative paths. With relative paths layers, tables, joins, and relates are automatically repaired if the data has the same directory structure.

    For more information on relative paths, see Desktop Help > Contents > ArcMap > Creating maps > Referencing data on the map > Storing relative pathnames to data for an entire map.

  • Move the data to the same directory. The join will be restored if the data and the join tables are in the same directory.

Article ID:000002959

  • ArcMap 9 x
  • ArcMap 8 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