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.