I'm really new to ArcGIS and have been trying to search for whether this is possible but don't know the correct terminology to look it up.
I have two layers on my map, one of lines and one of points. Both layers have a field called 'Route ID'. The routes taken are on the lines layer, with routes happening on many different days and sometimes going in the same places but sometimes in different places, so there are lots of overlaps from different days/times of routes on the map, but each line has its own corresponding 'Route ID'. The points layer is of observations made on a route, with sometimes multiple points recorded on a single route, and point has the corresponding 'Route ID' assigned.
I have edited my points layer so that only one category of observations is now present. However, this means I now have a few routes (too many to visually identify) that contain none of the category of observation I'm interested in. I want to remove these routes, so that my lines layer contains only route lines for routes that have a 'Patrol ID' that matches the 'Patrol ID's on the points layer.
The resulting lines layer would contain any line that had a matching 'Patrol ID' to a 'Patrol ID' found in the points layer. So basically what I'm asking is, is there a way in ArcMap to remove data from an attribute table in layer 1 where layer 1's 'Field Name' doesn't match any of the rows in layer 2's 'Field Name'?