>>>>Hi All:
>>>>
>>>>I'm creating a PickList Class. It will use a grid somewhat along the lines of inGrid (if you don't
>>>>know about that, doesn't matter).
>>>>
>>>>My first use involves selecting a record from the child record of a one to many relationship.
>>>>Specifically, I have a Client.dbf and an Address.dbf. A Client can have more than one address (a lot of snow
>>>>birds who spend 6 months in the north, 3 months in Arizona and 3 months travelling with a mail forwarding
>>>>address).
>>>>I want the pick list to have the first and last name along with the zip code, state, address, etc as separate
>>>>columns with indexes on each one, so that the use can select whatever index they want and incrementally search
>>>>the source.
>>>>
>>>>My problem.
>>>>
>>>>What should I use as the source for the grid?
>>>>How can I get all the different indexes available?
>>>>If I use a view that combines the 2 tables together, then I have to do a REQUERY() each time I want to change
>>>>the index (by a click at the top of the column), and that could get real slow when I have a lot of addresses.
>>>>If I use the DBFs set up in a relationship, how do I get the index to change from the parent table (set
>>>>relation to child) to the child table (set relation to parent), at a click().
>>>>
>>>>The only thing I can think of that solves most of my problems, is to duplicate the fields from the parent table
>>>>in the child table, so that all the indexes I want are in a single table. That creates a maintenance headache
>>>>because I can't make the last name a candidate index, so I can't use RI to automatically update the child table.
>>>>
>>>>Any ideas?
>>>
>>>Bill, I think you need to create a parameterized view as RecordSource for the grid. Then you can index the view on selected column.
>>>You can try to use some textbox search classes from UT Files section for your grid.
>>>Do you use any framework for your app? For example, Visual Fox Extend has all functionality you need built in their PowerGrid class.
>>>
>>>Nick
>>
>>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().
>>
>>I'm using the AppWiz framework. I've tried the StoneField, CodeBook, and MaxFrame frameworks. I always spend
>>too much time trying to figure out how to modify it to suit me, I figure this time, that it'll just be quicker
>>to build my own from the AppWiz.
>>
>>Bill
>Hi Bill,
>

>Use view myview
>for ix=1 to fcount()
>   cField = field(i)
>   index on &cField tag (field(ix))
>endfor
>

>Than set your inGrid cSearchTag(s) accordingly.

Thanks, I can't figure out how I missed something so simple. Don't suppose you have a recommendation about
where to put this code? Obviously it has to be done after the Requery(), so I'm assuming that I'd just put
it in the same place with the Requery().

Bill