Here's what I want to accomplish...
1) Setup a site on a host [CFMX7, MSSQL]
2) The site will be used by a company to track, create, edit, and add orders [no payment gateways, basically a content manager]
3) Users can carry a tablet notebook which they can access the site via wireless (no problem), but if they cannot connect via wireless, then have the ability for them to run a local version of the site, which will sync up data with the main site when they are able to connect.
So lets say we have company ABC, this company has 4 field employees with tablet notebooks. They visit customers to make estimates and will login to the site and begin a new order/estimate worksheet via a wireless connection. However if no wireless is available for them to use, they can still create a new order/estimate on their local machine, and when they login again to the site, that information will sync up with whats in the main database (update the main DB), as well as update their tablet notebooks, with anything new from the main database (and update personal notebook DB).
So I'm searching for some good ideas to accomplish this task. Or workarounds that may function better than what I mentioned above.
The overall goal is to create an application for a company that employees use in the field, even if they don't have an internet connection, and allow that information to sync up when they do connect again.
Points for the best ideas, or suggestions.