Detect duplicate entry of data in portal
I have users entering data in portal via a handheld scanner. All the entries must be unique and they can easily re-scan the same number by mistake. After each scan I want to review the previous scans in that scanning job and detect if they have previously scanned that number.
My strategy was/is to count the number of records with the previous scan and delete it if > 1 (if I commit the record or if 0 records if not committed).
Should I use and ExecuteSQL script statement to test for this or freeze the screen and do a find, count records...
Other quicker strategies to detect a duplicate field entry in two different portal records?