0

I have a data entry form that inputs a title, a date, & an attendance field. Is it possible to create a validation that looks in all those fields and compares them and if it finds one where all three columns match it will disallow the entry?

I don't mind if two of the three fields match, but if they all match I'd like to stop that duplicate entry.

Possible or no?

June7
  • 19,874
  • 8
  • 24
  • 34
Ben H.
  • 102
  • 7
  • 2
    Yes you can, by creating a multi-column unique index (see above). – Andre Feb 06 '18 at 08:26
  • That helped! Thanks. I guess I just didn't know what to search for. – Ben H. Feb 06 '18 at 10:12
  • No problem whatsoever. There are bad duplicates (where the asker could easily have found the question+answer), but this is definitely not one of them. – Andre Feb 06 '18 at 11:33

0 Answers0