Design and CSS styles
Version 6.x > Design and CSS styles > Drop-down based on another drop-down in BizForm View modes: 
User avatar
Member
Member
merete-grape - 11/13/2012 4:18:10 PM
   
Drop-down based on another drop-down in BizForm
Need help.

I have a drop-down based on an SQL query
SELECT SelgerID, Selger
FROM jotun_selgere

My next drop-down will use the selected from first drop-down.
SELECT SelgerID, Company
FROM jotun_kunder
WHERE SelgerID=[selected in drop-down over]

What is the right WHERE statement?

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 11/14/2012 5:07:56 AM
   
RE:Drop-down based on another drop-down in BizForm
Hi,

In version 6 you need to develop your own custom form control which will consist of the two drop downs and you will fill them dynamically in the code behind.

In v7, you can do it easily using the dependency fields as described in this article

Best regards,
Juraj Ondrus