This is how I did it by a triggered action. Note, with this workflow, you would be able to keep the previous value of a field,  it will not save the value of newly inserted record. first, duplicate the table which you want to have a history record. go to its table design and change its ID field to a text 255 and rename it "parent_id" or any  name you want. Your call, as long as it indicates that it is the records former ID. also, make sure that this field is not set to unique. Add a