2 Replies Latest reply: Feb 21, 2014 6:00 AM by Daniel Sturesson RSS

    Cross referencing in script



      I'm sure that I'm creating a post that there already is an answer for but I can not find it.


      I have a table that looks like the one below. What i want to do in the script is to look at the parent ID field. If there is a value I want it to find that row based on the ID field, copy the region value and put it in the region field for the row that has a parent ID.


      So, in this example I want Norway to inherit the region value Europe from its parent Sweden.






      Any help would be much appreciated.