>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

See Message #550474. I do not work with remote views myself.