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