I recently upgraded to ArcGIS 10.7 but I have been experiencing an odd issue ever since - this is the first time it has become really annoying/ problematic. I work for a water company, and I have a point layer with system valves in it that I am working on. When I open the attribute table it will claim to know 9679 Valves, but as soon as I sort it by the 'ValveID' field, the total number of records reduced to 5316. If I "Select all" on this layer, it then creates an improper fraction, saying that 9679 out of 5316 records have been selected. If I zoom to a Valve that has an ID number missing from those 5316 records, I can click on it and see the feature/ values the attribute table thinks doesn't exist.
Has anyone else run into this and been able to correct it? Right now it is a pain in the butt because if you look in the red box of the document I've attached, I cannot uncover what the next ID number should be in the sequence.