>Kent ---
>
>>
>>The problem that I am having is that user A updates a record. Changes city value from "Toronto" to "Chicago". User B updates the record and still sees "Toronto". If user B updates the record after the set refresh values have expired he will see "Chicago". Is there another way to update the buffer other than using set refresh?
>
>Yes! Look at CURVAL() and OLDVAL() with buffered tables. Trust me :-)
Thanks for your help John.
Looks like I have found a article regarding my problem.
Here is the address to the article. FYI.
Kent.
Article ID: Q190496
http://support.microsoft.com/support/kb/articles/q190/4/96.asp?FR=0