Posted by grichardomi on 10/21/83 11:29

Here is the situation:

Tables:
Account
AccountDocument
AccountTest


Then we have the following "Activity" table refencing "Account" table
above:
Table: Activity
Columns: ActivityID, AccountNo,...

when "Activity" with accountno is created, we'd like to able to take
snapshop or copy all Account related data records from tables: account,
accountdocument, accounttest
and store it somewhere.


This way even if account, accountdocument and accounttest tables change
later, then "Activity" accountno integrity in maintained.

Do we need to create or replicate similar tables to store data for
audit?

or Which other ways can this be achieved?

[Back to original message]