AnsweredAssumed Answered

Creating a Tracking Log

Question asked by ZoocMan85 on Mar 23, 2016

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

Outcomes