Auto Enter and Filtering

[Greg Hains]

Hi.

Does anybody know how to have a field or function setup so that I may type the first few letters of a word and not only does it do the AutoEnter feature, but actually limits the list (record/entry count) to data that meet that criteria? Furthermore, have it so it's not just the leading letters but any position of those letters of an entry in that list.

For example. I have a list with 50 names in it, starting with various letters. I start to type "SMI" - it jumps to names like SMITH. I'd like it to only show items in the list that have "SMI" in it anywhere - suh as GOLDSMITH as well.

Is this possible? I know it's tricky. My way of thinking is that it takes letter by letter and does a find on it, but within a drop down list environment.

If this is completely impossible, can somebody point me in the direction of something that may be similar?

Greg

[Vaughan]

Look "typeahead" and "clairvoiance" for demos of techniques, but they all involve portals and not auto-enter.

I don't know of any that do matches "inside" values: I'm not sure of it's utility. Most only match first characters.