Sharepoint 2010 List item dropdown options cascading -

Sharepoint 2010 List item dropdown options cascading -

i have 2 dropdowns "department" , "employees", section dropdown cascades employees dropdown. need select employees departments on alternative "all". note: there no section 'all', has select employees. using $().spservices.spcascadedropdowns http://spcd.codeplex.com/ have tried camquery not achieve.

so far, have not found way cascading dropdowns in sharepoint.

here few avenues hack way solution:

sharepoint designer (spd) has many ways customize (and break) pages. not sure recommend using spd since experiance has caused more side effects solutions far maintainability concerned. if have nintex forms available, there ways psudo-cascading drop downs editing input form. working in enterprise setting sharepoint, has been alternative me. on page fields, include webpart javascript filters list options based on selection of first column. has worked me in past it's been while don't have specific illustration you.

however! there catches associated putting javascript on page. particularly one:

here: http://geekswithblogs.net/soyouknow/archive/2011/04/06/setting-sharepoint-drop-down-lists-w-jquery---20-items.aspx

and here: http://www.sharepointboris.net/2009/10/sharepoint-lookup-field-how-does-it-work-and-how-to-add-javascript-event-handler-function-to-it/

[remember sharepoint runs own javascript too, such using jquery: http://www.stephanrocks.com/2011/10/05/_spbodyonloadfunctionnames-in-sharepoint-vs-jquerys-document-ready/ ]

sharepoint-2010 cascading