I have a record that has an autonumber field that says "3491". For some reason whenever I sort it, it gets sorted as if it were 3474. (The 3474 record is missing. and there is a duplicate 3491 record). When I try to delete this record, I get the error "The search key was not found in any record." I tried a repair database but to no avail. How can I delete this record (and others that are obviously due to corruption)? Thanks!



PS This record (3491) that sorts as if it were 3474 pulls into any relationships for 3474, but then pulls in records from fields autonumbered 3491!!!