2 Replies Latest reply on Jan 20, 2013 8:50 PM by jimcooper

    Move data table A to table B

    jimcooper

      Title

      Move data table A to table B

      Post

           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