This topic is locked

Dependent List Box with Multiple Dependencies

11/3/2011 3:32:20 PM
PHPRunner General questions
S
SirMoby author

I apologies if this has been addressed but I haven't been able to find it after a good bit of searching.
I like the dependent list boxes but if possible, I need something that can work with more than 1 dependency. For example:
Let's say that I have a 100 support technicians with 1/2 of them focusing on software support and the other on hardware support. They speak a variety of languages. If I select language as German and Support Type as Software I want a list of the technicians that speak German and are Software support.
Any ideas how to handle this?
Right now I would add a record for each language a technicians speaks and each type of product that they support but I need the dependent list bos to be dependent on more than 1 item.
This forum is a great learning tool.
Thank You!

Sergey Kornilov admin 11/3/2011

Since PHPRunner doesn't support dropdowns and listboxes dependent on two criteria here is what you can do.
Assuming that overall the number of languages is limited you can created a lookup table that combines both language and support type in one field i.e.
Hardware-German

Software-German

Hardware-Spanish

Software-Portuguese

etc
It makes the list longer though allows you to achieve what you need.