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

Four days of total frustration finally over thanks to you and Barbara. What can I say, y'all?? You are the GREATEST!

John