PROBLEM
Attribute tables for layers created from route event tables or XY tables display all records despite a layer Definition Query limiting the records. The features in the Data View are correctly limited by the Definition Query.
This is a known issue. This problem occurs when the table doesn't have an object ID column. For example, text file tables or tables from an OLEDB data sources don't support an object ID column.
Article ID:000004477
Get help from ArcGIS experts
Download the Esri Support App