Multiple SPCascadeDropdowns on 1 Form don't save.

Aug 19, 2013 at 11:10 PM
Edited Aug 19, 2013 at 11:12 PM
SharePoint 2007
JQuery - 1.8.3.min
SpServices - 0.7.2

I am using SpCascadeDropdown to cascade form fields. When I use 1 call to SpCascadeDropdown like so:
$().SPServices.SPCascadeDropdowns({
    relationshipList: "Method_Assets",
    relationshipListParentColumn: "Method",
    relationshipListChildColumn: "Title",
    parentColumn: "Primary Method",
    childColumn: "Primary Asset"
});
Everything works fine - the cascade works, and the data saves to the list.

When I add another call like so:
$().SPServices.SPCascadeDropdowns({
    relationshipList: "Method_Assets",
    relationshipListParentColumn: "Method",
    relationshipListChildColumn: "Assets",
    parentColumn: "Secondary Method",
    childColumn: "Secondary Asset"
});
the cascades still work. The problem is, when I have chosen values for all 4 fields previously mentioned, only the parentColumns are saved to the list. The values which are chosen for the childColumns do not save to the list. Any insight into why the data from child columns is not being written to the list?

-Aaron
Aug 24, 2013 at 2:58 AM
Edited Aug 24, 2013 at 2:59 AM
Aaron,

I'm a little confused about the relationship between the "Method_Assets" list, and its child list in which you are trying to invoke two cascading dropdowns. Is the "Method" column in the "Method_Assets" list required to have unique values. Otherwise, it would seem that the "Method" column in the child list would have the potential for duplicate lookup values. I partially mimicked the child list, as shown below, to give you an idea of what I'm talking about.

Image

-Charles
Coordinator
Aug 30, 2013 at 8:56 PM
Any outstanding issues here, folks?

M.