Hello,

I use two views in this scenario, mostly because the view used for displaying the records is, in fact, a join between two or more tables, and updates on this kind of view are a headache. :)

Hope this helps


>David,
>
>Thank you! Tried the trick. Although the grid stopped flicking, user will feel couple seconds hold because of the screenlock. Seems to user, the program "stuck" for 2 seconds and their mouse click won't work... I am upgrading backend database into SQL, the grid design works perfect currently with natual VFP table.
>
>Any other way to refresh my view for the grid without requery(i.e.,purge/refill)? Do I need 2 views? one used for display, the other used for update? or a local temp table and a view, where the table is used for display and the view is for requery and update my local table? the two will out of sync?
>
>Thank you,
>~Sheldon