Here's what I need to do:
When any field in a record is changed, I want to essentially do a "Save As" and create a new record in the same file with the new values and a time stamp.
I've read many posts in the Forum about audit files, so i can think of several ways to do this, but they all seem to be far more complicated than they need to be. I know I need to use Script Triggers, but I'm not sure the easiest way to save the original field values. If there were a simple way to save them, I could just save those as the new record and then save the changes in the current record.
Am I missing something very simple?