John,

Since I bind directly to tables or views I just use code like this in my form.SaveChanges() method:

if ( AnyChanges( "machine" ) )
   TableUpdate( 1, .t., "machine" )
endif

* AnyChanges.prg 08-Jun-98

lparameter pcTable

return ! empty( chrtran( getfldstate( -1, pcTable ), "1", "" ) )

TableUpdate() handles the actual field level replacements.

>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?