Cascade filter on two columns ? (newbie)

Mar 24, 2014 at 8:21 PM
Edited Mar 24, 2014 at 8:26 PM
Please pardon my ignorance, first time using Javascript and SPServices.

I am trying to filter "Description" to only show items that have the program and commodity from the previous two pull downs.

Currently "Description" is only filtering by the "commodity", and ignoring the "program"

I am sure it is something I am overlooking or not understanding.

<script src="../SiteAssets/jquery-1.11.0.min.js" type="text/javascript"></script>
<script src="../SiteAssets/jquery.SPServices-2014.01.js" type="text/javascript"></script>

<script type="text/javascript">


$(document).ready(function(){
    $().SPServices.SPCascadeDropdowns({
        relationshipList: "CorePrograms",
        relationshipListParentColumn: "Title",
        relationshipListChildColumn: "Program",
        parentColumn: "Title",
        childColumn: "Program",
    });  



$(document).ready(function(){
    $().SPServices.SPCascadeDropdowns({
        relationshipList: "Commodity",
        relationshipListParentColumn: "Title",
        relationshipListChildColumn: "Commodity",
        parentColumn: "Title",
        childColumn: "Commodity",
    });  




//Breaks out commodities 
$(document).ready(function(){
    $().SPServices.SPCascadeDropdowns({
        relationshipList: "ALLTools",
        relationshipListParentColumn: "Commodity",
        relationshipListChildColumn: "Tool_Description",
        parentColumn: "Commodity",
        childColumn: "Description",
    });  

 });
    });
});</script>
Any help would be greatly appreciated :)

As a side note, ALLTools has over 500 items in it and each item does have a program and a commodity as well as a Description, I am trying to reduce the lookup to be only the descriptions with a matching program and commodity from the other two pull downs.
Mar 25, 2014 at 12:01 PM
For some context:

CorePrograms List has just title column with program names in it (single line of text)

Commodity List has title column and contains commodity name (single line of text) and Program column contains Program Name (single line of text)

AllTools List has Program Column (single line of text) Commodity Column (single line of text) and Tool_Description (single Line of text)


My target list "Change Request" contains all 3 of the above fields and I wish to use cascading pull downs, right now programs to commodities works, commodities to description works.

However I need description to filter on both program and commodity which it is not doing at this moment.