Take a serious look at the new Windows Workflow Foundation. http://msdn.microsoft.com/winfx/technologies/workflow/default.aspx

>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