>I am currently trying to manipulate data in a SQLServer
>table.
>
> It is my understanding that
>
>1. to do this with VFP I must use a "Remote View" -
no, you can use SQL* commands like
SQLEXEC SQLCONNECT etc.
but I think remote views are better

>2. If I change recordsin the remote view, those records are changed in the back-end table on issuing a TABLEUPDATE or closing the view.

you have to set your view as updatable (see CURSORSETPROP and
DBSETPROP commands) for updates to happen
also in VFP5.0 you have off-line views which update the data only when they are turned on-line

Arnon