Move data table A to table B
Have table A with many fields including ID (serialized), PostDate, and Amount. When PostDate is modified, I need to create a new record in table B containing the values from three mentioned fields in table A.
Haven't been able to find a script method to create and populate a new record in table B while in a layout based on table A. This seems like common audit trail stuff, but forum search didn't get me anywhere. This should all be transparent to the user, without different layouts flashing on and off.
Can someone point me in a direction?