AnsweredAssumed Answered

Can the data source of related or joined tables be changed

Question asked by ChrisHalchuk on Nov 15, 2017
Latest reply on Nov 16, 2017 by asrujit_pb



Has anyone found a work around for changing the data source of a feature class, layer or table involved in one or more joins or relates such that the data source of the joins and relates are also updated automatically.  From what I have encountered, there is a bug (bug number NIM058535) in which a repair to the data sources in a MXD is not reflected in any joins or relates with the affected tables, or feature classes.  In my case, I have MXD workspaces that contain many joins and relates and the source data files involved have changed names, so by setting the data source to the data source with the changed name, I loose all my relates and joins.  Other than manually re-creating any joins or relates lost after a data source has been changed, has anyone found a work around to update joins and relates automatically with the new data sources. 


Note, I am running ArcGIS 10.3.1 (desktop) and the source files in the relates and joins are shapefiles and DBF tables.   Supposedly the bug NIM058535 I referred to was fixed at version 10.1 according to George Thompson who is with ESRI.  I must stress, that the names of the source files have been renamed and that I have reset the data sources in my MXD to the re-named source files. By re-setting the data source to the renamed files, the source links in the MXD are repaired but the joins and relates that existed before hand do not follow through to the new source files. As a matter of fact, if the source files with the original names are still in their original directories, the joins or relates will still refer back to the old data source even though the old data source is no longer loaded into my table of contents in the updated MXD with "repaired" data source links.


Thanks for any ideas