Thanks for the options:
I think the lookup from the original db is the only option I have since the field I am trying to update is a single-select field (per Setting dropdown value via formula , we can’t use a formula for setting the value).
I guess the third option is using a script to do all the update steps in one
Is there any value in creating a feature request for this or is there an underlying limitation which makes this difficult?