LifeinAsia - 10:39 pm on Oct 24, 2012 (gmt 0)

So even if they make their "correction" to the snapshot table, that correction has to go back to the live table as either A) an updated entry to the original transaction (with the same record ID) or B) a "correction" entry (with a different record ID). Either way, it makes more sense to make the update/addition to the live data instead of the snapshot data. Otherwise, you (and they) are just asking for trouble.