Dear all

I wish to develop an application with an SQL back-end, and VFP front-end, and also a web-based front-end that has access to the same SQL back-end. The front-end in VFP will be used in-house, with approximately 100 users, and is a case management system (workflow), and the web application would be used by the client so that they can view information about their respective cases, and also to view/download the management reports created by the VFP application.

Is my best option to link VFP to SQL server, or is it to connect VFP to .Net, and then .Net to SQL server, or is it something completely different?

Regards