>>>>>>>>Hi Nick
>>>>>>>>
>>>>>>>>How do I index the view? The only thing I see is the order by during a requery(). I don't like that idea,
>>>>>>>>because it forces a requery() each time a different column is selected, and that can take too long if there
>>>>>>>>are MANY records to requery().
>>>>>>>
>>>>>>>You can index the view with USE myView and INDEX ON... TO just as any regular DBF.
>>>>>>
>>>>>>I don't know why I overlooked that, but will it automatically update the indexes when I Requery() the view,
>>>>>>or do I have to re-issue the index commands?
>>>>>>
>>>>>>Bill
>>>>>
>>>>>Yes, the index is still open and updated in this case. You can easily experiment with this a little right from Command vindow. Just open your parameterized view, index it and try REQUERY()
>>>>
>>>>Thanks, I was going to get started testing that just as soon as I'm finished here. Nice to know that it'll
>>>>work before I start.
>>>>
>>>>Bill
>>>I thought it this way too as you know. I tested but it was not the case (disappointed), indexes were gone. Did I miss something ?
>>
>>Actually, the more I thought about this, the less I liked it.
>>Currently I have the picklist as a modal form that passes the selected record back to the calling form.
>>I have a mailing list with over 10,000 names and over 13,000 addresses and e-mail address (3 files),
>>that I want to be able to put into a picklist. I don't think I would want to wait for it to create
>>indexes for all the columns everytime I went into the picklist form. The only alternative I would have
>>would be to somehow have the form just become invisible (instead of destroying). That way the next time
>>the use wanted it, the indexes would already be there. This would require me to keep track of which form
>>called it in order to return to it, and somehow prevent the user from selecting a different window before
>>selecting a record.
>>
>>The other thread where you're showing me how you modified inGrid to accomplish this looks a lot more promising.
>>I tried modifying inGrid about 1 1/2 years ago, and never could get it to work right. I didn't keep the code,
>>so I'm not sure why I couldn't get it to work. I think I remember having trouble getting the Grid.RecordSource
>>to change tables and resetting the relationship. Hopefully, you've managed to solve that, and it'll work now.
>>
>>
>>Bill
>At first it didn't work by just setting recordsource="" and back to parentalias. So I added keeping the controlsources and restoring them as well. Than worked. Also without setfocus in gotfocus was pretty weird at first. Than I realized what was going on there. Anyway does it work for you now ?

I haven't tried it yet.
By the way what does the this.setfocus do?

Bill