I have a field with a pallet tag that is scanned. I have validation on this field to be unique in table, yet it does not check the SQL database to see if there is already a tag that is a duplicate of the one just scanned. Am I missing anything that needs to be added to this? I do have a live connection to the database as well. I've made the field in the SQL database unique, but it seems to be dropping the record instead of giving the user an error.