Modifications Table

[rhouse]

Two tables: second table (T2) is a duplicate of the first table (T1) plus it has a ModifiedDt (date field). The goal is to create a record in T2 after every modification & save of T1 with all the values (of T1) that have been changed.
What's the best way to accomplish this?

 

[June7]

If you want an audit trail, review http://allenbrowne.com/AppAudit.html

 

[rhouse]

Thanks, will review that article.

 

[jdraw]

See this link for an example using data macros for audit logging.

 

[LarryE]

(T2) is a duplicate of the first table (T1) plus it has a ModifiedDt (date field)

We never use duplicated table data in ACCESS. We link tables together using Primary Keys and Foreign Keys. Then we use Referential Integrity so ACCESS can work properly.

Please attach your ACCESS file so we can see if it was properly designed first. After it is properly designed, then we can discuss audit logging.