I want to add the ability for users to "jump" to a item on a lookup table by just typing the first character of what they think an item is called. I've searched here and looked at Dan Mass's article on "Intelligent Lookups" & Dr. Wayne's article on "Self-Filling Lookup Fields" at the LearnAlpha site but they're not quite what my customer wants. Dan's req's adding another column to the embedded browse where the lookup is done & our space is too tight already (I'm also intimidated by the scripting) and Dr. Wayne's appears to keep the user working in the field in the embedded browse table but my customers want to be able to work from the lookup table (some are very long and there's not always been a consistent method for filling in the descriptions of each line item so they're convinced that having the lookup table popup into view is best).
I've attached a sample set that uses a lookup table (specifically, a table of printer services and rates) that popups when you get to the "Oper id:" field in the default form of the Press_Costs table. Currently, you have to scroll thru the list of line items which is quite long in the working app that this sample is taken from. My customers would like to be able to just start typing the first several characters and have the selection bar "jump" down to the line item that is spelled that way.
I demo'ed them 2 commercial products that has something like this type of "jumping" and they prefer the 2nd of the 2 choices as described below.
- In the Palm desktop (V 4) if you're in the address book and type in a "b" the selection bar jumps down to the first listing starting with a "b." If you follow it with any other character nothing happens and the sel. bar stays on that first selection beginning with "b";
- In the PIM "Time & Choas" the first key stroke has the same result as above but when you key in a 2nd character (eg, "i") it jumps again to the first listing starting with "bi...", etc. This is the preferred kind of lookup.
Can this be done in A5V4.5 and, if so, how? W/O extensive scripting if possible??
I've attached a sample set that uses a lookup table (specifically, a table of printer services and rates) that popups when you get to the "Oper id:" field in the default form of the Press_Costs table. Currently, you have to scroll thru the list of line items which is quite long in the working app that this sample is taken from. My customers would like to be able to just start typing the first several characters and have the selection bar "jump" down to the line item that is spelled that way.
I demo'ed them 2 commercial products that has something like this type of "jumping" and they prefer the 2nd of the 2 choices as described below.
- In the Palm desktop (V 4) if you're in the address book and type in a "b" the selection bar jumps down to the first listing starting with a "b." If you follow it with any other character nothing happens and the sel. bar stays on that first selection beginning with "b";
- In the PIM "Time & Choas" the first key stroke has the same result as above but when you key in a 2nd character (eg, "i") it jumps again to the first listing starting with "bi...", etc. This is the preferred kind of lookup.
Can this be done in A5V4.5 and, if so, how? W/O extensive scripting if possible??
Comment