Use selected records from a related table in Model Builder

114
0
12-22-2021 11:33 AM
Labels (2)
RyanBohan
Occasional Contributor III

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.

0 Kudos
0 Replies