I have a unique field that contains letters and numbers. How do I set up an error message - warning, so that an entry is not duplicated?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Photo of Noel

Noel

  • 0 Points

Posted 4 years ago

  • 0
  • 1
The only way really is to use the Field Property setting to flag the field as being Unique.  Then the record will not be allowed to save.  Its not clear from your post if this is a data entry field or a text formula field.  If the latter, certain field types may not be used in the formula, especially lookup fields and formulas involving the Today() function.