Copy and paste values from selected features to a table in ArcMap?

Question

I am trying to find a more efficient way to select features from a polygon feature class and copy over their GUIDs to a separate table in ArcMap. I have a layer of pavement polygons and I would like to select all the sections of pavement that are receiving maintenance treatment, and then copy over their values into another separate table. The separate table has a 1-Many relationship with the pavement polygon layer.

Is there a tool in ArcMap or a scripting option to achieve this?

Here is a visual representation of my problem:

These are the selected polygon features and their attribute table. I want to copy the GUID values over to this table:

Note how this allows there to be a 1 Pavement Polygon to Many treatment records in the table possible. Right now I just do them one by one, but I was hoping for another solution where I could copy/paste over many polygon GUIDS into the table at the same time.

Answer 1

Using two cursors should accomplish what you want. You should be able to do your selection and run something like this in arc map python console:

with arcpy.da.SearchCursor(pavementPolys, ['GUID']) as pavement:
  with arcpy.da.InsertCursor(treatmentTable, ['GUID']) as treatments:
    for street in pavement:
      treatments.insertRow([street[0]])

This will insert a single new treatment row with that GUID for each selected pavement feature. If you've got a list of treatments elsewhere, you could work that into the code too to insert multiple rows representing multiple treatments done on a single pavement feature. Or you could make this into a toolbox script that will accept a selection and a treatment, and have it insert the treatment value into the table for each row. This would give you a more interactive way to approach the problem.

Answer 2

It looks like the Production Mapping Toolbar would be able to do this. Unfortunately it is not free or cheap. http://desktop.arcgis.com/en/arcmap/10.3/guide-books/extensions/production-mapping/adding-a-related-table-record.htm