AnsweredAssumed Answered

Move data table A to table B

Question asked by jimcooper on Jan 17, 2013
Latest reply on Jan 20, 2013 by jimcooper


Move data table A to table B


     Using FMP12

     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?

     Jim C