2. PHPRunner General questions
  3. Search using lookup rather than table entry
This topic is locked

Search using lookup rather than table entry

 		8/17/2009 3:40:20 AM
PHPRunner General questions
K
 kenny_robb author

I think I know the answer to this question but I thought I'd ask in case anyone out there has a solution.
I have a table and I have created a list page.

One of the fields on the page is "ID" and is INT(11)

In the editor I define this field as a lookup to another table and link it to the "ID"

I pull back a text name.
When I come to search on the table using "ID" it requires me to put in INT(11)

is there any way to let me search on the text name instead.
Thanks in anticipation
Kenny
J
 		Jane 8/17/2009

Kenny,
please check this article:

http://www.xlinesoft.com/articles/search_s...okup_values.htm
K
 		kenny_robb author 8/18/2009

As usual Jane you are a superstar and that solved the problem for searching normally.
The advanced search however is a slightly more interesting question.
I use the visual editor to define how I want the fields to look drop down, no drop down etc etc however the search screen does not want to be an individual. Whatever changes I make to that seem to replicate themselves to the the other screens. which then messes up those.
I am happy to have dropdowns in the add and edit screens but I don't want them in the advanced search screen.
Whatever I set in the edit/add seems to come through to Adv search and if I do it the other way it comes back through to the edit/add.....they just won't set seperatly.