2. PHPRunner General questions
  3. Advanced Search but working with dependent lookups
This topic is locked

Advanced Search but working with dependent lookups

 		9/7/2007 09:20:46
PHPRunner General questions
D
 daviesgh author

Hi,
On an advanced search, I have the following fields: Area, Region and Country. They are all using the Lookup Wizard. I want both Region and Country to be dependent on Area. When I run the Advanced Search Page site, after selecting a value for Area, the correct values for Country appear, but no values appear in Region. The order of the fields on the Search Page is Area, Region and Country.
If I change Country to not be dependent, then the Region works correctly i.e. Region is dependent on Area
To test this I created a new project in Build 304.
The fields appear to work correctly in Add and Edit Pages i.e. Region and Country are dependent on Area.
Regards,
Gordon
Sergey Kornilov admin 9/8/2007

Thanks, we looking into this.
N
 		nix386 2/9/2009

Hi there, just having the same issue as this person; I am using version 5 build 448.

Is there a way I can resolve this without having to remove the dependent lookups?
I am using these dependent lookups to fill region,state and postal code information automatically from the suburb field.
Example: Adding or editing a record with a suburb popsup the ajax lookup then completes the other fields from a locations db.

This works great however; When performing an Advanced Search and filling any of the fields other than Suburb, it fails highlighting the filled field with a red border!

A solution would be greatly appreciated.
Nick
J
 		Jane 2/9/2009

Nick,
unfortunately it's impossible to search through dependent field only.

You can create aliases in the SQL query on the Edit SQL query tab:

select field1,

field1 as field1_search,

field2,

field2 as field2_search,

...

from TableName


Then use field1_search and field2_search on the advanced search only and set up is as simple dropdowns on the Visual Editor tab.
N
 		nix386 2/9/2009

ok I'll try that thanks Jane, it's not a biggie but it would be convenient for some users.
Cheers, Nick