Unanswered: Duplicate Record Double Check Question
Is there any way to create a double check to see if a user entered in duplicate data that already exists in a table? I don't want this to prevent the user from entering in duplicate data, but just merely create a warning window alerting him/her that duplicate data exists. Each record in the table has 10 fields. I don't know if that information matters though.
First, you have to decide which field or combination of fields are considered duplicate and then there are various methods can be implemented. When it comes to names and addresses, this is nearly impossible because typos and misspellings will create a unique record. In this case the area code and the phone would be used as a check.