Use selected records from a related table in Model Builder

RyanBohan — Wed, 22 Dec 2021 19:33:57 GMT

I am trying to set up a model to make use of a related table, and make a section in one table and use what is selected in the other table.

Two tables:

Routes (only route names and numbers)

Route_Segments (many segments make up a route, each segment has unique attributes)

Outside of model builder I can make a relate between the two tables. Select by attribute from the Route_Segments then use "Related Data -> Routes" to show the related attributes. All the selected Routes that contain a Route_Segments the previous selection (using select by attibute) will be selected.

From there I can do a field calculation to update the Routes table, that one of it segments contains the attribute I am looking for. It's a binary field, and I only need to know if any segments of the Route contain that value.

The Route_Segments attributes change through out the year, so it would be nice to have a model scheduled to run monthly/quarterly to keep the Routes layer up to date.

topic Use selected records from a related table in Model Builder in ArcGIS Pro Questions

Use selected records from a related table in Model Builder