I have a table with customer data (Customer ID, Name, Address, City, State, Zip, Industry Code, Parent ID).
I would like to add an additional field: [Parent Industry Code]
Example Data below: In order the get the [Parent Industry Code] --I need to look-up and find the ParentID "CT879" that matches the CustomerID "CT879" and pull the Industry Code: 9090 from the matching customer record and insert into the into the child record's new field - Parent Industry Code: 9090
Customer ID: A123 | Name: Customer Big Name | Address: 7879 Park Ave | City: New York City | State: NY | Zip: 09379 | Industry Code: 8989 | ParentID: CT879 | **New Field** Parent Industry Code: 9090
Customer ID: CT879 | Name: Customer Bigger Name | Address: 8000 Park Ave | City: New York City | State: NY | Zip: 09379 | Industry Code: 9090 | ParentID: CT879 | **New Field** Parent Industry Code: 9090
My table may have 20,000 records.
Any advice would be much appreciated. Thank you!
