Checking for and acting on Finding an Existing Record
I have a Customer table with email address being the unique field
If I enter a new customer then the system will tell me if I've entered a duplicate value in this field and offer to Revert the record, BUT
I would like it to be a little more elegant...
I'd like a script that, when entering a new Customer Record and on Exiting (completing) the Customer Email field:
Checks if this value already exists in the database
If Not then I can continue editing the current new record
If so I would like the new record I'm entering to be reverted/deleted and to be automatically taken to the existing record