| Paul S. Person 2006-10-20, 6:55 pm |
| On 19 Oct 2006 13:07:58 -0700, "Josh" <jshhulse@yahoo.com> wrote:
>How do you create a lookup so that when a user starts to type in a
>Company Name that it filters down that search. Like a search engine's
>entry box. Filters down recent searches.
When I look up "locator" in the CW 2.0 Standard Edition Help File, I
find this information:
You start with a Browse Box (the help topic is "Browse Box control
template").
Even if you are not using the template, this section provides useful
information -- and if you use the template to build a test Browse
Procedure and examine the generated code, that will give you the
specifics.
Select "Default Behavior" at the top of the page and/or scroll down to
"Locator". It has a lot of information.
If you only want to filter by first letter, the "Step" loccator will
position the Browse Box to the first matching record.
If you want to filter by as many letters as the user types in, the
"Incremental" locator will do this. Every Browse Procedure I use has
one.
Note that the only field searched will be the first free field (the
first field not range-restricted) in the current Key. So, if Company
Name is the first field in the Key and if it contains the Company Name
in full, this will work. If it contains a foreign key to another file,
however, the search will be on the foreign key, not the Company Name.
Of course, if the foreign key reproduces the first few letters of the
Company Name, that may work well enough.
--
"I find that a great many things which have been conclusively
demonstrated by the Ancients are unintelligible to the
bulk of the Moderns owing to their ignorance"
|