I have table of ordered serial numbers with statuses, all statuses of these serial numbers are "Ordered". I would like to use barcode scanner to search and if match - change status of signe serial number to "Delivered"
You could create a "Receive Order" table.. with a field for the Serial Number. Then .. position the cursor within a row on that table and use the bar code scanner to scan the what was recived. You will either have to tab off that field .. or click a button .. then have an Trigger After Update that searches your above table.. if it gets a match, it can set the status to Delivered..
I am not sure what you want to happen if it does not get a match.. perhaps an alert message.