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.