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