Im trying to update a view that contains 2 base tables and just need to be pointed in the right direction. I know i cant just update the view as i will get an SQL error.
So im guessing what i need to do is
Get the updated data
Stop the normal update statement from being performed
Write my own update statements to update the 2 base tables
Just not sure on which server events i should be using and how
Cheers