Form Control

It sounds like to me that you are attempting to use cascading drop down lists, where by you filter one drop down list by the selection of another. Correct me if I am wrong.

I recommend creating a custom control with both drop down lists and do you logic and filtering with ajax.

I haven't tried this but you may be able to set the sql query to have a where clause using a macro that contains the value of the other field. If you set up your depending field attributes as well and set the visible property to a macro, you can only show one and then the other will load in after the first is selected. Theoretically this should work, but I haven't actually tried that. Wouldn't take much time to set up and if it doesn't work, then go the custom form control route.

Joshua,

I have tried that method before and was unsuccessful - I remember being extremely disappointed that those dependent field settings didn't work the way I had hoped. I too believe it'll need to be a custom form element of some type.

8: https://docs.kentico.com/display/K8/Developing+form+controls 7: http://devnet.kentico.com/docs/7_0/devguide/index.html?developing_form_controls.htm