Replacement of old product codes

  • Thread starter Thread starter Ramesh
  • Start date Start date
R

Ramesh

HI,

I have a Productcode table with fields Oldcode and Newcode. Now I need to

replace the ProductCodes in the Order table, the old Codes with the

corresponding New codes.


How can i do this other than tediously using Find & replace? Is there a way

i could create some Update query to pick up from the Product table and

replace?


Thanks for any help.

Ramesh
 
Create a query with your Order table and your Productcode table linked on the
prod code in the order table to the old code in the productcode table.
Add just the prod code from your order table into the query grid.
Change the query type into an update query and in the update to row of the
prod code, put [new code]
e.g. the field name of the new product code from your Productcode table.
Save and run the query.
 
Thanks very much Dennis... you saved some painful work for me. more than
the pain, the fear some integrity in data will get lost.

This is simple and clear.

Thanks
Ramesh

Dennis said:
Create a query with your Order table and your Productcode table linked on
the
prod code in the order table to the old code in the productcode table.
Add just the prod code from your order table into the query grid.
Change the query type into an update query and in the update to row of the
prod code, put [new code]
e.g. the field name of the new product code from your Productcode table.
Save and run the query.

Ramesh said:
HI,

I have a Productcode table with fields Oldcode and Newcode. Now I need to

replace the ProductCodes in the Order table, the old Codes with the

corresponding New codes.


How can i do this other than tediously using Find & replace? Is there a
way

i could create some Update query to pick up from the Product table and

replace?


Thanks for any help.

Ramesh
Click to expand...
Click to expand...
 
Dennis, what would be the simplest way to add another field with the new
product codes rather than replacing the old codes? so i can have both the
old and new codes in the orders table.

Ramesh


Dennis said:
Create a query with your Order table and your Productcode table linked on
the
prod code in the order table to the old code in the productcode table.
Add just the prod code from your order table into the query grid.
Change the query type into an update query and in the update to row of the
prod code, put [new code]
e.g. the field name of the new product code from your Productcode table.
Save and run the query.

Ramesh said:
HI,

I have a Productcode table with fields Oldcode and Newcode. Now I need to

replace the ProductCodes in the Order table, the old Codes with the

corresponding New codes.


How can i do this other than tediously using Find & replace? Is there a
way

i could create some Update query to pick up from the Product table and

replace?


Thanks for any help.

Ramesh
Click to expand...
Click to expand...
 
Dennis, what would be the simplest way to add another field with the new
product codes rather than replacing the old codes? so i can have both the
old and new codes in the orders table.

Ramesh


Ramesh said:
Thanks very much Dennis... you saved some painful work for me. more than
the pain, the fear some integrity in data will get lost.

This is simple and clear.

Thanks
Ramesh

Dennis said:
Create a query with your Order table and your Productcode table linked on
the
prod code in the order table to the old code in the productcode table.
Add just the prod code from your order table into the query grid.
Change the query type into an update query and in the update to row of
the
prod code, put [new code]
e.g. the field name of the new product code from your Productcode table.
Save and run the query.

Ramesh said:
HI,

I have a Productcode table with fields Oldcode and Newcode. Now I need
to

replace the ProductCodes in the Order table, the old Codes with the

corresponding New codes.


How can i do this other than tediously using Find & replace? Is there a
way

i could create some Update query to pick up from the Product table and

replace?


Thanks for any help.

Ramesh
Click to expand...
Click to expand...
Click to expand...
 
Back
Top