2. PHPRunner General questions
  3. look up table for search page
This topic is locked

look up table for search page

 		5/19/2009 7:40:01 AM
PHPRunner General questions
W
 webmanager author

On my search page I have three fields that have values added dynamically (Lookup Wizard - lookup table) this works fine.
BUT
My problem is that they show up as drop down lists on the ADD NEW page, obviously I need this as a text box so the user can enter new data.
So, how do I do this? Any help please this is a very urgent problem.
J
 		Jane 5/19/2009

Hi,
create aliases for these fields on the Edit SQL query tab:

select field1,

field1 as field1_search,

field2,

field2 as field2_search,

...

from TableName


Then set up different settings for field1/field2 and field1_search/field2_search on theVisual Editor tab.
W
 		webmanager author 5/19/2009

Thanks for your reply - I'll try your suggestion.
W
 		webmanager author 5/19/2009

Thanks Jane,
you saved my skin today, simple solution I got it to work first go.