I'm working on building a database for my baseball cards. I have been fighting the challenge of setting up a validation field. I've got one that is working but now I'm wanting to expand on it. I was thinking a script trigger but not sure. This is what I have envisioned, as you see below I have the validation field visible with the required fields. I'm wanting that validation field to be hidden while normal data entry but when a validation fails that the validation field reappears and has the failed validation field highlighted or in some fashion so you know that is the duplicate field. Such as, I've entered the same card into the same location, I would like the location to be highlighted so I know that it is duplicated some where in that field. For the validation field, I have a simple calculation List calculation, and then for the validation field it mimics the List calculation with a unique calculation.
Duplication mean all fields in the list calculation are same as existing another record, so you can't say "location is duplicated", set of field values are.