On Mar 30, 2006, at 7:30 PM, Wong TC wrote:
> Got a client want me to quote him a system where he have 5 car
> shops in
> different location and every location have car inventory system
> installed.
>
> Now he want every location upload/download the latest data to/from
> his HQ
> office, how i am going to do it? please advise.
>
> can it be done in VFP?
It could, but it might be tough.
> System asked to quote
> 1. Car inventory system - Car control (Inventory system)
> - Master Files
> (Supplier,Client,Car
> Details)
> - Transaction Files
> (Pruchases,Sales,Adjustment,Transfering...)
> - Access level -Security
> control for
> the user.
> - Print Receipt (Deposit paid)
> - Print Invoice (Outstanding
> amount)
>
> 2. Every branches able to see other branch available car and can do
> the car
> tranfering from 1 location to location.
>
> 3. Using dial-up connection to upload data to HQ server.
With dial-up, you will need to limit the amount of data going across
the connection. You would probably be best using a real server
database, such as MySQL or PostgreSQL at HQ, and then use VFP to only
query for the records needed, or send the new/changed records.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
©2006 Ed Leafe |
