0 Replies Latest reply on Mar 23, 2016 5:38 PM by ZoocMan85

    Creating a Tracking Log

    ZoocMan85

      I have two tables, customers and tracking log. What i am trying to do is when the field in customers Active Brew List is modified, this field is a check box field.  i want a time stamp and a custom message to go into my tracking log table. The tracking log table consists of the following fields.

       

      Tracking ID

      Tracking Customer ID

      Tracking Date

      Tracking Message

       

      This data will be viewed in a portal window in a layout that's table =customers.

       

      Customers Table and Tracking Table are linked in a relationship by the customer ID. So in order for the tracking logs to display , the customer ID has to be copied over to the tracking log table .

       

      What is the best way to write a script for this ? Thanks for your help.

       

      Ray