Automatically Updating Fields based on values in another table.

  • Thread starter Thread starter Strugglin'
  • Start date Start date
S

Strugglin'

We have several dbases, with tables making references
to "Inventory Numbers". We have now gone with a new
numbering scheme in our facility, and all these inventory
numbers need to be changed. I have an Excel spreadsheet
with two columns: Old Inventory Number and New Inventory
Number. If I were to import this table into the existing
databases, how can I automate the process of updating the
related fields on the other tables?
 
Pretty Simple if you don't have foreign keys connected to the inventory
number
Query (replace tables & Fields as required):

UPDATE INVENTORY A INNER JOIN NEWINVENTORY B ON A.INVENTORYID = B.OLDNUM SET
A.INVENTORYID = B.NEWNUM

HTH

Pieter
 
Back
Top