Hi, please excuse any general ignorance, im a newbie at access.
The problem:
There are two columns of product codes. The 1st is for the original part and the 2nd its replacement code.
eg. Orig Part Repl Part
A0000000299 83091446038
A0000000320 A0000002404
. .
. .
There are over 100,000 cases.
The problem is that there are codes in the 2nd column found in the first column which means that they in turn have also been replaced by another code.
eg. Orig Part Repl Part
a b
b c
What is needed is to convert the cases from the above form to a form something as follows:
eg. Orig Part Repl Part1 Repl Part2
a b c
(and so on until there are no more replacements.)
Any advice, help or pointing in the right direction would be greatly appreciated.
Thanks
The problem:
There are two columns of product codes. The 1st is for the original part and the 2nd its replacement code.
eg. Orig Part Repl Part
A0000000299 83091446038
A0000000320 A0000002404
. .
. .
There are over 100,000 cases.
The problem is that there are codes in the 2nd column found in the first column which means that they in turn have also been replaced by another code.
eg. Orig Part Repl Part
a b
b c
What is needed is to convert the cases from the above form to a form something as follows:
eg. Orig Part Repl Part1 Repl Part2
a b c
(and so on until there are no more replacements.)
Any advice, help or pointing in the right direction would be greatly appreciated.
Thanks
