This topic is locked

Search 'problems'

12/7/2006 12:07:18 PM
ASPRunnerPro General questions
D
dunga author

I have certain columns set as dropdown menus.
I can use Advanced search with no problems

but if I type part of the dropdown in a simple search, the search gives no results
for example
my drop down menu has the following 3 values:
ONa(RN)

ONA(RPN)

Registered Nurse
If I use simple search with
any fiels, contains RN
I get NO results
If i use adnvaced search and use the drop downed selections NO problems -- I find everything I need.

however if I TYPE inside part of the value get NO results

Sergey Kornilov admin 12/7/2006

I guess in this dropdown box Link field and Display field are different.

Search is run against Link field while you trying to enter a part of Display field which belongs to another table.
Advanced search page allows you to pick a Link field value to search for.
If you like to run a search against values that are in another table you need to modify SQL query to pull data from both tables at once.