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.