>>>Edward and Barbara:
>>>
>>>I finally have the view properly established, optimized, and functional. It updates immediately, and its contents are right on. My only remaining problem is that I can't get the grid to show any data. The RecordSourceType is Alias, the RecordSource is v_Payments (the view), and each column is bound to the proper fields. In my test case, the view has one record (correct) and the amount of the payment is correct. But nobody can see it except me through VFP queries. Any ideas???
>>
>>There are few steps to wake up a grid. The first thing you may try is to issue Grid.Refresh right after Requery("view"). If it's unsuccessful, then the next step is to call
>>Grid.Recordsource=""
>>Grid.Recordsource="myview"
>>Grid.Refresh
>>This is harsh way, and if you are forced to use it, it may require some more adjustment. Try it and let us know how it goes.
>
>Edward:
>
>Worked like a charm! I had tried the Grid.Refresh() already to no avail; however, wiping out and re-establishing the RecordSource solved it all.

Glad to hear it, but now about adjustment. Make a simple test: change width of some column interactively and then invoke requery("view") again. You may see (at least in most cases) that column width changed back automatically and your users may complain about this. The adjustment means in that case that it's not enough to restore Grid.RecordSource only. In some situations you'll have to restore Column.Width, often it's also Column.Controlsource. Do not get scaried, all who started grids went through this.