Thanks for the info. I need to rethink the way I'm going to handle look-up tables and I'll probably go with views.
-snip-
>
>There is a way to get an immediate update without losing the buffering. Switch your source to an updatable sql view based upon the same sql code. Open the view in your data enviroment and make it the source
>
>Now when some adds a record, simply append blank to the view and add it in.
>
>(With buffering "append blank" and "replace" is fine -- no need to do an insert into.)
>
>Now it will show up immediately on your users combo box, and still load into the table when you do a tableupdate (assuming no locking conflicts....).
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!