Sheldon,
I would use a single view, during the refresh phase you should give your users some sort of visual cue that the data is being refreshed. Client/server apps just have to work a little differently than native VFP tables, some things will be faster some things will be slower, you set the user expectations.
>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?