This issue is a little tricky one to describe. In my previous post, I was not able to articulate requirement well enough. Sorry for repeating the question.
Trying a second time, this time with aid of some pictures to illustrate the issue better.
Imagine two tables that are unrelated i.e they do not share any columns in common.
The second table has a virtual column which needs to be overwritten whenever a row is selected on view for first table.
In this contrived example of Name and Address, since row for Name1 was selected in first table, all values of Field3 in second table will will be updated with “Name1”
PS: In case you are wondering, my plan is to have a view on second Table come up and show information that was computed using Field1,2 and 3 of that table. Please disregard this additional information if this background info is confusing.