>>You'll need to use SQL commands with SQL Server. You can use remote views to
>>make this easier. As for creating query screens, look at QBF Builder from
>>www.classycomponents.com.
>
>So if I understand well, it is not possible to make an application that can work with both client/server and local foxpro database unless much overhead is accepted and the choice of the database will be a basic issue in planning how the user interface will look like ?

Nope. You can create an application that can use both VFP & SQL tables. Always use views in both cases. Then you can switch the dataenvironments on the fly to use local vs remote views.