How do I add 'Last User' to a field?

[keelbolt]

On each of my tables I have a 'LastUser' field that should show the name of the last person to modify a record on that table. How do I get the name of the last user who has modified that record to be written automatically into that field?

Can't find this in any of the documentation or google, but it must be a standard operation for most tables!

[Lee Smith]

I think what you are wanting is a Field Modification or Audit Trail. Take a look at the links of this Post.

Link [color:blue]by mr_vodka

HTH

Lee