Thank you Gail Shaw.

I will try to write a trigger on the tables and solve this issue.

For this line ' values should get insert/update in the view respectively' what I meant was, if any insert/update happens, they reflect on the view.

But got a clear view on views. Thank you one