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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
