I did. But it was not so much that the one record has changed but that various records scattered throughout two tables (companies and contacts) have changed "in composite" (I don't know how else to describe it).

BTW, my wife grew up in Pointe Claire (Pierrefonds to be more exact) before her family was hauled away to Ontario during the 70's. We visited there a few years back and like most places, it has grown and is unrecognizable from those days!

Albert

>>It is not so much the record that has changed as it is the related text files that have changed. And yes, I use GETFLDSTATE() or in this case, I use OLDVAL() and compare it against the current value to see if the text in that particular field has changed such that I need to update that one record.
>>
>>Thanks
>>
>>>Have you thought of using GETFLDSTATE() to detect that something has changed in any of the fields in the table:?
>
>I must have misread your question, I thought you were referring to content of a memo field, not a text file.