The best I can think of is to take advantage of the data/time
fieldtype.

Compare the central data at the end of the day
with the local data and make a fresh set of data.

and finally distribute all the newdata back again at all location.

It would also be interesting to see other solutions from fellow
members

Ajay Sanghani
WinSmart Solutions
Building Softwares Better and Faster !
http://www.winsmart.com



>One of my clients use a finished app on more than 5 independent locations. There is no connection between these locations (they don't want to use online options). They want to deal with their customers from any location. At the end of the day they want to synchronize data on all locations (deletions, additions and editing). They guarantee that on a given day a particular customer's data would be edited, added or deleted from one point only. I have a lot of tables and relations but any add, edit or delete operation takes care of cascaded updates. Calculation and balance data are managed through local views. I developed a stategy to do job but seeking a better way.
>Thanks
>Cetin