>The SQL database is on a remote server and the offices are located in different locations and they use the same SQL database on the remote server. The shared Office Table has a row for each office with a field for the last transaction Id which will be incremented for each office transactions.

So the app will go to this table to get the next ID for adding a new client or some other kind of activity? If so, why not just use an IDENTITY column in the table for the ID and include an OfficeID in each row that indicates ownership? Why play games with the IDs?

-Mike