How can I bulk relate thousands of features to a related table?

Question

* I have a point feature class with tens of thousands of features, all with a GUID.
* I also have a table with a single record of information I wish to relate to every single feature in my point feature class. This record also has a GUID.
* I have successfully set up a relationship class between the point feature class and table inside of my geodatabase, based on the origin and destination GUIDs.

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.

AlexMorris · Answer

If it is one to many you select the many and the one related parent and just add selected to the parent single feature as shown in the other replys and esri documentation of add selected to relationship. This way you can add many at once and all children will be related to parent. I personally have done it with python / arcpy an example was posted as response to another thread.

https://community.esri.com/t5/arcgis-pro-questions/add-selected-to-relationship-programmatically/m-p/1269673/highlight/true#M66923

If the correct field is populated with the feature GUID in the related table the relationship is created from inside out.

Will_CulturalFire · Answer

Hi Brittany,

I know this is an old post, but I recently worked through this problem myself. I don't know if this would work for an attributed relationship, but if the relationship is not attributed, here is the workflow you are looking for:

1. Select all parent features.

2. Use Append tool to append these features to the maintenance table. Map the GlobalID of the parent FC to the foreign key GUID field of the maintenance table, and disable all other fields (unless you want to transfer other attributes).

3. There will now be one blank related record for each parent feature.

BrittanyBurson · Answer

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.