I'm have a view that uses social security number (SSN) as the update key. I noticed that all records with the same SSN were getting updated. I added last name, first name and date of birth as keys and it worked fine. Is there a way to have only the current record update without explicitly stating specific fields? What does the database check when you mark "No duplicates?" The database knows that they are not the same records somehow, but when I update it seems to require the additional keys. Thanks!

Regards, Renoir