At 01:47 AM 11-11-02 +0000, you wrote:

>OK, thanks for another thorough reply!
>
>Are you saying though, that once set up, the user will see the open-
>case data in the combo, but when certain letters are hit, it uses
>the upper-case column for selection?
>I'm getting a little confused, but will definately give it a try.

Yes, that's exactly right.
In the ColumnAttributes *for the open-case column* set the CASE INSENSITIVE
attribute to true AND name the proxy column in the field alongside
it. That's all you have to do to get the high-performance case-insensitive
search on the open-case column.

The other parts of implementing this are, of course, to create the proxy
column, to write the two triggers for populating it and to index it.

Helen