Searching for duplicates in FM11
I am attempting to find records in a table where people have registered twice for an event. My find criteria are (1) a serial number in the event serial number field and (2) a ! in the contact serial number field.
I would expect this to find records for that specific event where the contact serial number is duplicated.
Instead, I'm getting all registrations for the event, which is impossible since there are 144 different registrants with 146 registration records. In other words, I know at the outset I have two duplicates. I just can't find them.
What am I missing?
Thank you in advance for your assistance3.