David,
Thanks for your suggestion. I did lookup this function but can't really get clearcut idea of how to implement this to work correctly with my situation. How can I properly use this function to REPLACE a value in one of the field within the same table whenever ANY data within the same RECORD changes? Can this function be used to "automatically" update a field value regardless of if the change is via interactively or programmatically w/o duplicating code to constantly check this function in every form/code that use this table/views?

Any more details on this solution would be greatly appreciated.

>John,
>
>Look at the GetFldState() function.
>
>>I need to log a change made to a record within the record itself. For example, if any data within a record changes, I want to mark one of the field with a flag (e.g. logical .T.). I've been trying to set this up with table record rule or update trigger but can't seem to get it properly to work correctly. Anyone have any ideas?