>1- Store the register sales data in local tables on the "cash-register PCs" and read them into the server table as a part of the daily closing process.
>2- Store the register sales data on the server.
We use an off-the-shelf package that runs on our cash-register PCs, and as apart of the daily closing procedures, the cash-register machine dials into the server and uploads *summary* data to the server. We originally had it set to upload the entire sales detail data, but came to discover the summary data via SQL query was satisfactory for accounting and much more efficient on system resources. HTH
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos