Re: Created by & modfied by
Ossama22 - the first question is not HOW, but WHAT you want to do. IF all you want is the name, date, and update/insert - then putting an event routine for BeforeInsert and BeforeUpdate would work. However, this leads to questions like:
Do you only want to know who inserted it and who LAST updated it? Or do you want a bit more detailed history like - every time it was updated? What about a record deletion (if you allow that at all)?
People sometimes use a separate table to make an audit log. You can search this forum for the word "auditing" and the phrase "audit log" to see MANY articles on the subject.
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.