Apply user name to a field?
I'm in the planning stages of a database for workflow. In the future, I'm wanting to implement a feature as such...
Once a user selects a certain value in a field (either controlled by drop down or radio buttons...I haven't decided), a script runs that enters their initials into another field (basically for tracking purposes).
Would I need a table that references the username login to their initials? What other fields/features might I need?
Thanks for the help.