I'm not sure about the SQL Server views....but you can do it the way you're doing it now but use remote views instead of local views.

>Until now, I´ve been using parameterized updatable views to retrieve, edit and update records from some tables.
>
>Let`s say, in a form with a grid, the grid is bounded to a view, so I only have to "requery" the view to retrieve data, and "tableupdate" the view to get records inserted, updated and deleted in the related table(s).
>
>Now, I`m facing my first project using SQL-Server as a data Back end and my question are:
>
>How (if possible) do I get the same functionality described above?
>
>Are SQL-Server views updatable and "parameterizable"?
>
>How do I get the base table(s) of a view updated from changes made to the view?
>
>TIA.
>
>Cristóbal.