Hey Daniel,

Actually, inserting and updating views for multiple tables via INSTEAD OF Triggers is one of the touted improvements in SQL 2K. See BOL Designing INSTEAD OF Triggers.

For whatever reason, though, no matter what I try, I am unable to get the @@IDENTITY to respond inside the Trigger. The one small example that is in BOL uses a know value (SSN) as the PRIMARY KEY for the first table, and therefore has it's value to put as a link into the 2nd table.

For security reasons (another touted reason for views), I do not want to have the tables written to directly. So far the only other method that I seem to be able to get to work is just using a stored proc to do the insert, and leave the view non-updateable.

Thanks for your input.