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 Customer ID
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.