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