I need to create a activity log on my system, the activity log is until field level,For example if person A open a document and make changes on the customer name field only, when the person A save the document, in the activity log will show person A change the customer name field.The system also need to print the activity log report.Any Ideal ?
Subject: Activity Log
You can capture the field values in the postopen event of the form into form-level global variables, and in the querysave compare the actual field values with the variables to determine what was changed. Ofcourse, this will have a performance impact.
cheers !!
Ashish