Brenda,

You might consider hiring someone to come in and consult with you on the design, then you and your group could fill in the pieces.

Rod Paddock and Jim Duffy did a large app for a bank using VFP front end and SQL back end. Try contacting www.takenote.com .



>I have a medium sized application written in VFP 6.0. There are approximately 45 free tables, 100 forms, 40 reports, and 100 programs. The app was converted from FoxPro. The core was rewritten when moved to VFP but the fringe forms were simple converted from FoxPro to VFP. Anyway the app is a hodge podge. It is installed at about 30 sites and each site has about 5 clients who each access it over the Novell network.
>
>Now my baby, and I, need to grow up. My company wants to move from 30 sites to a single site with a centralized database. Currently the response time on my application is too slow to allow all my clients (which are in FL, GA, TN, VA) to access a single copy of my application. My company is also throwing out buzz words like Sybase, SQLServer, Unix - but nothing is offical.
>
>I am at a lose as to what to even start researching. Intranet, Client/Server, whatever. Where should I start looking for answers?
>
>Thanks
>
>Brenda