Find and replace values from a table

[Darrell Childress]

I have a database with links to our accounting system (written in Visual
FoxPro). We are getting ready to do a lot of key changes to customer
numbers in the accounting, which means we have to make the same changes
in the Access database to keep consistency with the data. Is there a way
that I can create a table containing 2 fields:
OldValue
NewValue

and then create a query which will do a find and replace (or I suppose
an update query would be more appropriate) that will pull the values
from this table?
Hope this makes sense. Thanks,
Darrell

 

[Jeff C]

You will have to create a way to link the current data you have in access to
the new data you will have in the accoutning system. This may involve
creating some extra temporary tables. Joining the two and using an update
query will probably be your easiest way to update the Access database to
whatever is current in Accounting. You can import just the columns you want
creating a new temporary table in access to do your updating from.