Table W has Work Orders and Table A has Assets.
w.WOPK, w.AssetPK, w.AssetID, w.AssetName
and
a.AssetPK, a.AssetID, a.AssetName
I need to re-assign WO's to different assets of the same ID and Name, but different PKs.
I imported a duplicate, more accurate copy of assets. The names, and ID's are the same, but the PK's are not.
How do I re-assign the WO's tied to the old assets, to the new assets?