Subject Re: [IBO] incremental search on multiple column sort
Author Helen Borrie
At 02:38 PM 5/12/2004 +0000, you wrote:

>Thanks Helen,
>That does clarify some information about how to setup the ordering
>information in the query, however I still do not have results like
>what I expect.
>Regardless of how I order the result set, I cannot "find" anything
>with a NON_SEED_ITEM = 1.
>I have this for the OrderingItems now:
>with OrderingItemNo=-1 the NON_SEED_ITEMS are sorted first like I
>expect, but in the IB_LISTBOX the row never moves when I type in
>search. Using my results from below for example: when I type
>in "Ba" nothing is found. I expect the row would move to "Bag".
>When I use OrderingItemNo=1, the results are again sorted like I
>expect AND I can find "Tom" for Tomato, but I can find nothing when
>I type in "Bag".
>Do I need to set something that tells the control that I ONLY want
>to search in the ITEMNAME field for the incremental search.
>I've set the search to be case insensitive, so that's not an issue.

You would need THIS:
> and OrderingLinks to:
> NAMEONLY=ITEM=2 (or -2, if you want the default to be descending).
and the lookuplist SearchKeyByKey property set true.