4 Replies Latest reply on Aug 13, 2014 10:02 AM by RickWhitelaw

    Checking for and acting on Finding an Existing Record

    RBowering

      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