I am sure someone has encountered this before, but I cannot find any guidance about it.
I have a point feature class with the locations of assets and a linked table for inspections. The table has no location information, only the feature class has locations.
Assets noted to be in poor condition during inspection, I want to see on a map.
It is easy to apply a filter to the inspection table for poor condition, but on the map all assets still show. How do I get the feature class records showing on the map to match the filtered table records?
For example, when I apply a filter to the table, there are 45 records meeting that condition. However, there are 2700 records showing on the map (all asset records). What I want to see on the map are just the 45 assets meeting the table's filter condition.
Ideas or links to posts or documentation addressing this are appreciated.
