>ok, now that two have the same data.
>What if I edit record 1 in table "B", which the same record exists in table "A" too. Am I able to detect the changes in "B" when append from "B"?
Tan,
Things are getting complex. Why you want to detect changes now. If you want the both tables be identical all the time then you could only use one table (tableA or tableB) in both systems. Why a need for two tables ?
Cetin