Hi all!

I'm working on a inventory-stock management/invoicing of truck parts selling project. The backend will be Firebird server and the frontend foxpro. The easy part (database, stored procedures, triggers,etc.) is (almost) finished but now comes the hard part.
We will open branches (5 at the beginning, but many in the future) in other cities and everything must be kept on one server. Every branch must be able to sell truck parts from other branches and everything must be done real-time. The server will be online all the time with static IP and broadband cable connection (256kbs).
I don't know now yet the type of client connections, but I think that will be the same type.
Here is what I've thought to do:
-the client application will be Foxpro GUI type, not WEB interface .
-connections from clients to server through ZeBeDee secure tunnel. This utility compress and encrypt network traffic between clients and server (any other utility?).
-download lookup, static and partly static tables at client location (categories, products, customer list) and check for changes at server side from time to time. If something is changed, download only changes. I think that these tables will be offline remote views.
-the rest, with remote views and SPT when needed.

Any pros/cons from experienced developers ?

I hope that I succeded to made myself understood, my english is not so good.

TIA