Please Help

[Al]

I have a stand alone table for 17 clients, that I imported
into my database, called "tbl17cases". This table is for
clients that have been reassigned a new ID. In this table
there are 2 fields one has customerIDs used through out
the database(OldID), and the other field has new
reassigned IDs(NewID). We need to keep the old records as
is but instead of updating the old ids with the new ones,
I need to go in every table in my database find all
records that has the old IDs copy these records and then
append them to the same table with the new ID for every
customer. Can someone help me please.
thanks
Al

 

[Larry Linson]

At a very high level, sounds like a good job for some queries... perhaps a
Make-Table query to create the copies with the New ID (data sources would be
the original table and the table of new and old ids) and an Append Query to
append those back to the original table.

I suspect with some work, it could all be put in one query, but as it is a
"one-off", there seems little justification for doing so.

Larry Linson
Microsoft Access MVP