I have a table Projects which has a 1 to many relationship with Notes.
I'd like to be able to add the logged on user to a field in Notes every time a new notes record is added.
i.e. Notes structure is currently
id
project_id
details
I'd change it to
id
project_id
details
user