Add a text field to the table. In field options, set it to auto-enter the AccountName on modification.
No script needed.
Great, I tried it and it worked but I going to add a second field to auto enter time stamp on modification to accompany the one you recommended to suit my needs. Thanks.
1 of 1 people found this helpful
You could add both pieces of data in the same text field if you auto enter a calc, such as: "last modification by: " & Get ( AccountName ) & " at: " & Get ( CurrentTimestamp ).
Probably will not implement what you suggested of entering the calc of get account name and current time stamp as your first suggestion answered my question. (As I would want my coworker to also check the occasional record that I and by anyone else altered; so she only needs to check by date); But I am going to play with the calc so I at least I will know how to do that.