AnsweredAssumed Answered

Checking for duplicate records by field on record creation

Question asked by willrollo on Aug 21, 2014
Latest reply on Aug 28, 2014 by philmodjunk

Title

Checking for duplicate records by field on record creation

Post

     Hi

     Can someone explain the best way to check that a record does not exist when i create a new one - specifically by the 'name' field.

     I have a very large customers database so want the check to be quick on creation of new record - I assume the script would execute when the user exits record? The name field is automatically calculated as an auto enter calculation of first and second name or company name. 

      

     Thank you

Outcomes