Sounds great! One more reason to keep moving in that direction. Dwayne
From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Easter, David Sent: Monday, July 13, 2009 12:59 PM To: arslist@ARSLIST.ORG Subject: Re: Allowing users to enter leading characters in search menu field ** Another solution would be to upgrade to AR System 7.5.00 - which includes the Auto-complete capability on the web. Auto-completion in menus For forms that are viewed in a web browser, you can turn on an "automatic complete" feature for character fields that have a menu attached to them. When this feature is turned on for a field and a user begins typing text into the field, a list of values that match the text appears. When multiple values are presented, the user can change the selection with the up and down arrow keys or using the mouse. To select a highlighted option, the user presses Enter or clicks it. To enable this feature, select the field in BMC Remedy Developer Studio, and set the Auto Complete and Auto Complete Match By properties accordingly. See the "Automatically completing menu entries" section of the Form and Application Objects Guide. -David J. Easter Sr. Product Manager, Solution Strategy and Development BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of marti...@ad.jmu.edu Sent: Monday, July 13, 2009 8:35 AM To: arslist@ARSLIST.ORG Subject: Allowing users to enter leading characters in search menu field ** Dear List, I have a "Department" field (field ID 1000000000), with choices listed in a "Department Form." I want users to be able to either click on the Menu button and see all choices, or enter one or more leading characters and see the choices that begin with those letters. (Eg, type in "Eco" and then see "Ecology" and "Economics" in the menu.) If I have no qualifications in my menu it shows all choices. If my qualification says: 'Department' LIKE ($1000000000$ + "%" ) It works if the user enters a leading letter or two, but if there are no leading letters it says, "(No entries in menu)." I tried: $1000000000$ = $NULL$ OR 'Department' LIKE ($1000000000$ + "%" ) But still got "(No entries in menu)." 'Department' LIKE ( "%" + $1000000000$ + "%" ) works if there are no leading characters, but if there are leading characters, it offers choices in which the leading characters appear anywhere in the Department name. (Workable, but not ideal.) Any suggestions? (ARS 7.1 p3, RH Linux server, Oracle 10.2) Dwayne Martin James Madison University _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"