I have a interface that when the operator scans the internal ID barcode an sql query runs in the background for part id and part serial number from table x. I have a timer that runs every half a second and if the serial and part number have a length greater than 4 it updates table y.
This works but i will get duplicates some times and it seems a bit clunky.
The reason that i did it this way was so the operator can scan 5 to 20 parts quickly and add them to a batch in a table.
If there is any ideas on how to streamline this or any resources that you can direct me to that I might be able to find an answer it would be appreciated.
Thanks