View Single Post
  #9 (permalink)  
Old November 28th, 2006, 12:37 PM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

You have to decide what goes into the transaction table.

Like, if you have a table with these fields:

NameID - PK
FName - text
LName - text

And you want to see who does what in the table, create a form that is unbound, but allows users to create or modify records in this table. Then when a record is modified, let's say, you record this in the tblNameTrans table:

TransID - PK
NameID - copy
FName_Old - old value
FName_New - new value
LName_Old - old value
LName_New - new value
UserName - the user that made the modification
DateCreated - date/time default Now()

For grins, you may want to store the transaction table in a totally different database, and just send the data there on the before insert and before update events of a bound form.

Lots of ways to do this.

Reply With Quote