I have two tables with lists of serial numbers in each. I have created a form that allows me to add a new serial number to the second table, I simply scan the serial number into the form and click submit, this adds the serial number. The problem I have is that the serial number still exists in the first form. How do I automatically delete the serial number from table one when adding to table two using a form?
Many Thanks