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?