Experts,

I need some advice.

I have 2 databases One on my Server (\\backoffice\HHD) and on on the PoS terminals.

When the back office changes anything how can i Make it so that the PoS terminals will update thier copy of the database?

Example if a price change is done on a product the PoS will use the new price becasue they are running from the network database BUT if they system goes offline they will divert to the local database.

My problem is HOW can I keep the local database uptodate when ever anything is changed on any of the databases on the back office?

I have the following databases to keep uptodate
> products
> Cashiers PoS
> mutisavers
> PoS Settings (recipit settings, card settings etc)

I Was thinking about deleting the databases and just copying them again BUT this will be two slow if I have 10-20 terminals downloading at the same time. also I just want to update the feilds that have been changed eg

PoSPrice = "0.56" change to "0.72" I just want it to update this NOT the whole recorld.

Any recommandation is most welcome

Thanks for the advice

Drew