Problems with duplicates
I have 3 fields: Last Name ( Text field ) First Name ( Text field ) Full Name ( Calculation of Last Name & First Name )
If someone enters the Last and First Name of a name that is already in the database, I need a dialog box to come and say, "There is already someone entered with the same first and last name."
Then, the entry that is already in the database would display directly below the record that is trying to be entered with the same last and first name. The options would be:
1. Continue - which would allow the duplicate and the user could continue adding to the record;
2. Delete - which would delete the record the user is trying to create and show all records and allow the user to continue.
I know this should be easy, but I'm a novice and I can't find what I'm looking for. Can someone show me a script that I could use which would trigger after someone tabs out of the Last Name field?