Hi,
I use a temp table to gather information from a bar code scanner, simply a machine ID number from 1-999. I want to update another table, then clear the temp table to start another 'batch'.
I need to compare if the item is a valid id in this table, then update a yes/no field within that...