I need to update multiple tables. I have created a view to all the tables I need to insert records into.
The page loads fine, but I get this message that the view is not updatable because the modification affects multiple base tables.
I thought this was the purpose of views. If not, any other ideas how I can insert into multiple tables??
Thanks!
N