I have a table that contains an item number and a location number. I want to take each of the item numbers and look in another item cross reference table to see if it exists. If so, I want to update the original item number with the new one.

"If so, I want to update the original item number with the new one." In which feild???

can u be a bit clear.....