Open your view in the View Designer and select the Update tab. Under "SQL Where Clause includes", make sure you've selected "Key Fields Only".
>Hello,
>
>I have a form which contains three different grids for a child table. Each grid's rowsource is a different view for the same child table. The view takes the parent record's key value as a parameter. The child table has almost 800,000 records.
>
>In the grids, the users can manually edit a 255 character field and then move off of the record in the grid. I'm noticing a lag in the screen refresh when the user changes the field value and moves off of the current record. I'm assuming the lag is caused by the view's update.
>
>The child table that the views are based upon are indexed on every field other than the one being updated, and I can't index that one since it's over 240 characters. I've set the Optimize property to .T. in the grid.
>
>Can anyone think of any other way to speed up the view's refresh and minimize the delay when moving off of a changed record in the grid?
>
>Thanks in advance,
>
>Ben
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer