AnsweredAssumed Answered

Checking for and acting on Finding an Existing Record

Question asked by RBowering on Aug 12, 2014
Latest reply on Aug 13, 2014 by RickWhitelaw

Title

Checking for and acting on Finding an Existing Record

Post

     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

      

     Thank you

Outcomes