>>>>>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
In fact I would suppose to put it in init event of your code or DE.afteropentables so the code would be executed once.