Cascading dropdown woes

Jul 28, 2010 at 6:04 PM

I have created three lists exactly as I see them here: http://spservices.codeplex.com/wikipage?title=%24().SPServices.SPCascadeDropdowns including data insuring the lookup columns are pointed where they should be.

I also used the script exactly as it is on that page as well:

$(document).ready(function () {

        $().SPServices.SPCascadeDropdowns({
            relationshipList: "Regions",
            relationshipListParentColumn: "Country",
            relationshipListChildColumn: "Title",
            parentColumn: "Country",
            childColumn: "Region",
            debug: true
        });
        $().SPServices.SPCascadeDropdowns({
            relationshipList: "States",
            relationshipListParentColumn: "Region",
            relationshipListChildColumn: "State",
            relationshipListSortColumn: "ID",
            parentColumn: "Region",
            childColumn: "State"
        });
});

I receive the error:

parentColumn: Country

Column not found on page

I believe I am missing something very basic that will be embarrassing when we figure it out.  Does SPServices.SPCascadeDropdowns extend dropdowns or are they a control unto themselves?

Environment:
SharePoint 2010 Webpart in Visual Studio
Windows Server 2008R2
jquery-1.4.2.min.js
jquery.SPServices-0.5.6.min.js

My thanks in advance,

 

Coordinator
Jul 29, 2010 at 2:57 AM
Edited Jul 29, 2010 at 2:58 AM

The error message is saying that you don't have a column on your form called "Country". Once you've set up all of your relationship lists, you need to use them as the sourse for lookup columns on another list. That's where you'll call SPCascadeDropdowns on the form(s).  So the three lists [Countries, Regions, States] end up just being "helper" lists for a fourth list. In my usual example, it's a list called Sales Opportunities where I want to track where the opp is coming from.

Hope this helps.

M.

p.s. As you can see in the SPServices documentation, SPCascadeDropdowns should work fine in SP2010.

Jul 29, 2010 at 3:05 PM

Marc, forgive me if I am coming at this from a completely wild trajectory. :) 

I am not using designer at all. I have a Visual Studio Web part that starts like so:

using System.ComponentModel;
using System.Web.UI.WebControls.WebParts;

namespace CNIC.Training.SPSvcsTest
{
    [ToolboxItem(false)]
    public class SpSvcsTest : WebPart
    {
        protected override void CreateChildControls()
        {
        }
    }
}

I don't 'have' any columns at all.  All I have are a few lists and some script that i am trying to create dropdowns with.  If I am trying to use the tool in a way it was not designed for then please let me know.

My humble thanks in advance,

Coordinator
Jul 29, 2010 at 3:09 PM

Odds are good that this won't work, then. The script is looking for specific constructs in the DOM, and your Web Part is unlikely to have those constructs. Obviously, there's no way I can predict that sort of customization in my code.

M.

Jul 29, 2010 at 6:59 PM

Thats Great, it answers my issue.  Thanks for the support! 

Coordinator
Jul 30, 2010 at 3:56 AM

You bet. Sorry it won't work for you...

M.