I have a field called CUSTOMER which contains a number such as C00001,
However i now have a new field called XCUSTOMER which is the new number that they relate to.
CUSTOMER C00001 now relates to XCUSTOMER 493845.
CUSTOMER C00002 now relates to XCUSTOMER 494343.
Basically there are hundreds of these and i dont have the time to manually enter the data. I just want to say "where customer = C00001 then insert 49494 into XCUSTOMER and then loop through and insert them all.
My table is called CUSTOMERINFO.
If anyone could help it would be much apprieciated as it would save me so much time.