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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"