I have a two part answer.
The first suggestion is that if you are able to calculate the value for the Related Zip code, then just change [Related Zip Code] to b a formula field equal to that field to be formula field just equal to the value of [Record ID Zip].
But if you need to retain the ability to do manual overrides, then make a manual override field and then make the field for [Related Zip Code] to take the value of the over if entered, else, use the [Record ID Zip].
My second answer is that this can be done with Automations, but the first answer is a much better solution, so I hesitate to go into detail for the Automation solution.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
