Cascading Dropdown with Jquery Webservice

Dec 10, 2009 at 3:19 PM
Edited Dec 10, 2009 at 3:27 PM

Hi Marc,

I have implemented Cascading Drop Down  its working but not the way data has been setup in list i am getting Duplicate value,also if i select parent site then in second dropdown there is no child site even if there is 

Child site for parent site. here is working Code

$().SPServices.SPCascadeDropdowns({

                                                relationshipList: "{GUID}",

                                                relationshipListParentColumn: "Parent_x0020_Site",

                                                relationshipListChildColumn: "Child_x0020_Site",

                                                parentColumn: "Parent Site",

                                                childColumn: "Child Site",

                                                debug: true

                                });

Here is the data in Parent site list  and Child site list

Name of Parent site 

Johnston McLamb Main Consulting Operations Corporate Committees Strategic Planning Sales & Marketing

New Parent Site

 

Parent site                      Child site Name

Consulting Operations      Delivery Management Consulting Operations Amgen Consulting Operations DoC Consulting Operations Internall Association of Fire Chiefs (IAFC) Consulting Operations USDA Consulting Operations USPS Committees Wellness Committees Charitable Contributions Committees Career Development Committees Events Planning Committees Intern & College Hiring       New Child Site   N/A Main  Corporate Library

Now with this data if i select Committees then there is no data in child site drop down even if there is data.

Second if i select Consulting Operations then  i got duplicate for USPS.

Any suggestion on this.

Coordinator
Dec 10, 2009 at 3:41 PM

Are the columns lookups like I describe in the documentation?  If not, you may not be getting exact matches.  I don't see how you could be getting a duplicate for USPS given the data you've shown above.

M.

Dec 10, 2009 at 4:02 PM

Hi Marc

I did follow your documentation and Implemented based on that document. 

Coordinator
Dec 10, 2009 at 4:25 PM

Well, obviously something isn't right. ;+)

M.