If I start an edit session, I am able to add my selected table record to individual features using the attribute window, as outlined here. However this is not time efficient for the number of features I have.
Is there a way to bulk relate my table record to the thousands of features I have? Is there a geoprocessing tool that will do the job?
I am running ArcGIS 10.3.1.
Are the GUID fields populated with values?
The manual process you describe above will only need to be used if child GUID is not populated. For example, say I have the relationship between a feature class called Airports and a table called Districts based on the FCC fields. I can select the airport, and the field in the Districts table that should be related:
I can then right-click on the District value in the Attributes window and choose to Add Selected to Relationship.
After doing so, the FCC field will be updated with the FCC value from the Airports feature class:
If the FCC fields are not populated, there is no way for the relationship to know which features are related without doing this manually.
Thanks Jake. Yes, I did have GUIDs populated in both Origin and Destination tables.
I was able to resolve my situation by doing the following:
I'm not sure if there is a more efficient way of establishing relationships in more recent versions of ArcMap or ArcGIS Pro. If there is, then my issue will hopefully be better dealt with in the future. Alternatively, is it not possible to create a 'Relate' geoprocessing tool which can establish relationships between tables once the relationship class has been selected?
Unfortunately I don't have access to the Production Mapping extension Justin was able to use to accomplish this in ArcMap. In my case, it would be enough for me to bulk create blank related records in a maintenance table, and then go back and batch edit their fields. For example, select the length of a street containing 15 median features, right click at the table header level >> Add New to Relationship, and it would add a record for each parent GUID selected. Then I'd select those child records and batch edit to "schedule" them for maintenance. However, having to click each one at a time to Add New to Relationship for thousands of street medians isn't feasible... unless I am missing where this is possible? Hopefully it will be considered to add this capability into Pro in the future.