What is the best way to track who was the last person that edited a record and when it occurred.
I almost always have a few fields in each table, created by, created on, modified by, and modified on. They are set to auto-enter the account name and the timestamp for each for just the purpose you're requesting.
Now this works very well for a base table, but depending on your needs, you may want to track (or not) any related record as well. Normally, I don't do this as the related table will have the same set of fields (but their own data) and that's tracked there. But in some instances, I've had clients that want to track contacts and contact notes, but want the contact record to show the last change on the contact record, or in the case of a note that is a more recent change, the last modified timestamp of the note. In those cases, using Max or a script trigger to update takes care of the request.
In addition to a creationTS field I also use a creationDATA field that gathers a whole bunch of details when a record is created. I find a simply modificationTS not all that useful as it only records the fact that something was changed. I prefer an Audit Trail field, as it can keep track not just of the last modification but all mods, and it can reveal exactly what was changed, when and by whom. NightWing (Ray Cologon) has an excellent product available:
NightWing Enterprises - UltraLog v2.x Audit Logging System for FileMaker
Retrieving data ...