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 :-)
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
