2. PHPRunner General questions
  3. PHPRunner - Dropdown is dependent on... Breaks on Second
This topic is locked

PHPRunner - Dropdown is dependent on... Breaks on Second

 		12/15/2005 1:18:47 PM
PHPRunner General questions
P
 peterski author

I've followed the various tutorials in these Forums and the help file and mamaged to create TWO dynamic lists, however, I can't seem to create a third dependant list.
Have a database as so:
DB: Company Records (Details)

Company_id

Company_Name

Company_Address

Business_Category_1

Business_Category_2

Business_Category_3
DB - Business_Category_1

Business_Category_Id

Business_Category_Name
DB - Business_Category_2

Business_Category_Id

Business_Category_Name

Business_Category_Name2
DB - Business_Category_3

Business_Category_Id

Business_Category_Name2

Business_Category_Name3
I want to have THREE cascading drop down boxes.

So that when I select say "Business Services" from DB - Business_Category_1, DB - Business_Category_2 will show a list of categories, one of which will be say, "Computers", which will in turn make Business_Category_3 show a list of categories in the "Computers" parent category from the DB - Business_Category_3 table , e.g. "Computer Equipment", or "Computer Profesionals", etc.
Can someone show me how I can do this using PHPRunner please?

Am I doing something wrong here?
Peter W
admin 12/16/2005

Peter,
the current PHPRunner version doesn't support multiple dependent dropdowns.

However we'll add this feature to next version and we have a patch for the current.
Please download and apply the patch:

http://www.asprunner.com/files/linked_patch.zip
Unzip it to C:\Program Files\PHPRunner\source\include folder and rebuild your project.
B
 		btouleau 1/17/2006

Does it posible to do that with PHPRunner 3.0??? and how can I do?
admin 1/18/2006

Peter,
PHPRunner 3.0 supports multiple dependent dropdowns.
It seems to me that you have unusual design of your tables.

You should use ID instead of Name to link categories.
So Business_Category_2 table should look like:
Business_Category_Id

Name

Business_Category_Id1 - a link to Business_Category_1 table.
And Business_Category_3 table:
Business_Category_Id

Name

Business_Category_Id2 - a link to Business_Category_2 table.
Then set up three Lookup wizards on Formattingtab in PHPRunner and choose Dropdown dependent to options for Business_Category_2 field:
Link field - Business_Category_1 (from Company Recordstable)

Filter field - Business_Category_Id1 (from Business_Category_2 table)
And for Business_Category_3 field:

Link field - Business_Category_2

Filter field - Business_Category_Id2