2 Replies Latest reply: Jun 9, 2011 2:30 PM by David Bonnet RSS

    Update row value(s) in resident table?

      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