>Ahh! You're absolutely correct. Thanks.
>
>-snip-
>
>>
>>I guess you work with buffered table. Select-SQL retrieves records from the base table, skipping all buffered changes until you Tableupdate().


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....).