Home > FAQ > Database > Searching for duplicate keys using multiple key fields

Searching for duplicate keys using multiple key fields

QUESTION: Can I search for duplicate social security numbers (SSN) within each status code?

ANSWER: Yes. When searching for duplicates, define both SSN and status as key fields. ProVal will find duplicates where both SSN and status match.