This content has been marked as final. Show 2 replies
The attached image explains it all, I'm looking for the "cleanest" way to update a row in resident state from the same resident table. Basically I need to replace all null rows in one field with actual values from a different field (again both in the same resident table).
What comes to my mind is the lookup() funtion and join. I couldn't find any easy solution or function in the community but I'm thinking somebody has ran across this before.
Thanks for your ideas - DB