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