Dear List,
A different problem from the one I submitted a few minutes ago
To review: 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 letters and see
the choices that begin with those letters. (Eg, type in "Eco" and then see
"Ecology" and "Economics" in the menu.) The qualification for the search menu
says:
'Department' LIKE (( $1000000000$) + "%" ) OR $1000000000$ = " "
That works, thanks to some good advice from the ARSList.
I also have a "Dept ID" field (field ID 565000194) with choices listed in a
different field in the same "Department Form." The qualification in my search
menu says:
'Dept ID' LIKE (($565000194$) + "%" ) OR $565000194$ = " "
This menu brings in every Dept ID in the entire Department Form regardless of
what I type in the field.
What am I doing wrong?
(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:[email protected] ARSlist: "Where the Answers Are"
