>I am wondering if it makes sense to use VFP as a user interface to a database accessed through MSSQL ? If so, is there any literature anyplace that describes how you do it ?

You can start with the book "Client-Server Applications w/h Visual FoxPro and SQL Server" http://www.hentzenwerke.com/catalogavailability/csvfp.htm