Hello Alvin,
In addition to the useful links in Sergey's reply, you can try the book "Client/Server Applications with Visual FoxPro and SQL Server" by Chuck Urwiler, Gary DeWitt, Michael Levy & Leslie Koorhan. The book is published by Hentzenwerke Publishing. You visit the website at
http://www.hentzenwerke.com/.
>Can anyone give me some tips on how to use VFP with an MS SQL database?
>
>I've tried using remote view but how can ou edit records in a remote view?
>
>TIA