Hi all!

I've started a new client-server project, for our sales department (truck parts sales), and I need to chose the best approach regarding lookup tables. We have huge lookup tables, with thousands of records(products table, cross reference table), 2000 customers all over the country and so... The issue is that we need to design the system for future point of sales. I don't know yet the type of connection with these POS, but I'm sure that the connection will be very slow compared with a regular LAN.
Everything need to be centralized on a single server, all transactions must be recorded at a single location (we need to know if the part is available in other POS) . These huge tables are not 100% static tables, are modified from time to time. One solution can be to "cache" locally these tables, but what if gets changed at server side? (we have an unstable economy, prices need to be changed often)

I will use Firebid SQL server and I can think about stored procedures, triggers, but I am fairly new to this field.

Any ideas?
Thanks.