The design phase is underway on a project I'm involved with and I'm soliciting opinions on the validity (or lack thereof) of the current
approach.

The purpose of the application is to provide users with the capability to report project progress on a quarterly basis using an Internet-
based interface that transfers data from its temporary storage place (the web server) to its permanent storage place (a file server) once
the entire report has been completed. The forms to provide information for the quarterly reports consist of a fair amount of unlimited text
controls in addition to textbox, option group, etc. controls. Data will be stored in VFP tables, and the browser interface is planned to be
done with Cold Fusion. Cold Fusion does not need to be the ultimate tool for the interface but is preferred (i.e. a mgmt decision).

It is intended to have a series of DLLs (automation servers created with VFP5) existing as a middle tier that performs much of the data
handling tasks required of the browser interface. VBScript will be used in conjunction with Cold Fusion to invoke the middle tier DLLs as
needed. The back end database will be a VFP5 DBC. As previously stated, tables in the DBC containing reports that have been completed will
reside on the file server, and reports "in progress" will reside on the web server. Reports "in progress" are envisioned to be offline
views that are subsequently brought back on line (flushed back to the tables in the DBC) when the reports are complete.

Over time, there will be a lot of storage required by the memo fields in the DBC tables, and the file server will be able to accommodate
these reqts. There will exist modules on file server for query and reporting (probably using Crystal reports) that operate on "completed"
report data.

I'm interested in hearing any success/failure stories with projects that have or had requirements such as these as well as any critique of
the current approach, positive or negative. The current concerns are (1) is Cold Fusion/VBScript sufficient to perform the tasks required
of the front end inteface that needs to invoke middle tier VFP5 DLLs, (2) are VFP5 offline views a good choice to store the reports "in
progress" on the web server as opposed to a table/DBF file.

Thanks in advance
John