This is fun, Derek. We should do it more often. <g>

>Not right now. It seems our clients are extremely security concsious - so they will either upload orders from their websites or the brave ones will connect to SQL servers through IP addresses and run window Forms on laptops.

You want to talk about security conscious ... our customers are cops and firemen. The firemen probably don't care all that much, but the cops sure do. Web Services are not a problem for security-conscious users ... simply connect to the Web Service via https instead of http. Security issue resolved.

>I will probably subclass the controls for Forms with properties that contain all of the table/field/type info, loop through the fields on the Form and build that typed DataSet that way (makes sense?). This is the current plan but that could obviously change.

I don't get what you're saying here, unless it's something along the lines of using your old Forms (from your old VFP app?) to figure out what data you need to capture and to model your DataSets from that? Seems backwards to me. Database design should be the first thing you do, and your DataSets should be based on the result sets you'd get back from Stored Procs.

~~Bonnie