we have offices in different locations with non stable internet connect, so we are planing to have filemaker server on each location, then write script to sync data, but there are some questions that I can not solve, please if anyone could help.
say at both office A and office B, we have same data 1, 2, 3, 4, 5
then office A delete data 3
then office B add a new data 6
at the end of the day, we get these data sets
A - B
1 - 1
2 - 2
4 - 4
5 - 5
then if I build a relation between table A and table B, how could I find 3 is delete at table A, then I will go delete it also on table B, and how can I find 6 is the new record on table B, then I will write that to table A too.
Thanks a lot for solving this puzzle.
Tunghua from Taiwan ROC.