I am using a remote view of the table. When I click add I want to be able to see the ID. How do I set up the stored procedure to fire on insert? I know I have to use the SELECT newid=@@identity but I don't know how to get it to work.

Yes I have a parent-child situation

Tyler