[Base]: How to insert user name of the person who altered the record?


Within a form, how to insert into the record the current user name of who altered the record?
Basically, how to put the results of SELECT CURRENT_USER(); into a table (a defined row) at the time the record was altered within the form?



Wherever you are writing this information to it would require some sort of macro code.

It is probably better to write a trigger to do this. See MySQL Triggers

I thought briefly about macros as I found this option under the events but the triggers look so much better. Thank you very much for this.