Removing value from first column is not updating third column

Jan 20, 2011 at 11:54 AM

Hi,

I want to create three cascaded multivalue lookup columns (For eg. Area -> Country -> City). In these columns values are coming from three different SharePoint lists (Areas, Countries, Cities).

For this, I am creating newform.aspx and editform.aspx for my list and using SPCascadeDropdowns function from SPServices on these two pages. Everything worked like a charm. But in testing I found one bug in this implementation. Here is the scenario:

Select Values from Area column (For eg. EMEA, APAC etc..), then second column is populated with respective countries (For eg. Spain, Finland, China, India etc..). Now select values from Country column and based on this selection Cities are populated in third column City. Select multiple cities from this column also.

So selection went very well as expected, but when I remove EMEA from Area column, second column values are removed accordingly but third column values are not changed, which is something not acceptable by the users.

Please let me know how can i resolve this issue. Thanks in advance.

-Prashant.

Coordinator
Jan 20, 2011 at 11:58 AM
Prashant: This sounds very similar to my own test scenarios, so I'm not sure what's going on. Are Countries and Cities both multi-select? Also, can you post your calls to SPServices? M.
Jan 21, 2011 at 1:26 PM

Yes all three columns are multivalue lookup columns.

Here is the code.

<script language="javascript" type="text/javascript" src="/_layouts/nokia/js/jquery-1.4.2.js"></script>

<script language="javascript" type="text/javascript" src="/_layouts/nokia/js/jquery.SPServices-0.5.7.min.js"></script>

<script language="javascript" type="text/javascript">

            $(document).ready(function() {

                        $().SPServices.SPCascadeDropdowns({

                                    relationshipList: "Countries",

                                    relationshipListParentColumn: "Area",

                                    relationshipListChildColumn: "Title",

                                    parentColumn: "Area",

                                    childColumn: "Country",

                                    debug: true

                        });

                        $().SPServices.SPCascadeDropdowns({

                                    relationshipList: "Cities",

                                    relationshipListParentColumn: "Country",

                                    relationshipListChildColumn: "Title",

                                    relationshipListSortColumn: "ID",

                                    parentColumn: "Country",

                                    childColumn: "City"

                        });

            });

</script>

Please let me know if you have some solution for this.

Thanks,

Coordinator
Jan 24, 2011 at 1:50 AM

Prashant:

I'll have to try to reproduce this to see if it is a bug. I haven't had anyone report this in the past, and it may be because you're using three multi-select columns, which is unusual.

M.

Coordinator
Jan 24, 2011 at 1:51 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.