Cascading dropdown in sharepoint 2007

Question

I have a requirement like cascading dropdownlist for eg: 2 dropdowns (country and state) if I select United States in the country drop down it should display all the states in United States in the state dropdown list.

Can any one help me, how to state with or else send me the relevant links.

Thanks in advance

Answer 1

I've blogged about that subject here: http://feeds.feedburner.com/~r/PaulGalvinsSharepointSpace/~3/197160316/cns!1CC1EDB3DAA9B8AA!469.entry

 

HTH,

 

Answer 2

Download this from Codeplex solved the issue for me

http://customfieldcontrols.codeplex.com/

Answer 3

Refer this link

http://datacogs.com/datablogs/archive/2007/08/26/641.aspx

Answer 4

Anna, the link that u have given does not work.

---

cool

Answer 5

You can refer following link if the above does not work.

http://blog.12thwave.com/?p=7

http://www.sharepointsnippets.com/post/2008/11/SharePoint-Cascading-Dropdown---Unlimited-siblings.aspx

You can also download code from the same

Answer 6

The above mentioned code is not working for "Edit in Datasheet" mode. It just show the fields as read only in Datasheet. Do you have any solution which works for both Edit Properties and Edit in Datasheet.

However it's also not working in Document Information Panel. But i am just looking for "Edit in Datasheet" mode. Anybody solved this issue?

Thanks!!

Answer 7

One more possible solution http://www.sharepointdrive.com/blog/Lists/Posts/Post.aspx?ID=8

Answer 8

We've made the jQuery Library for SharePoint Web Services available on Codeplex.  With it, setting up cascading dropdowns is a snap.  For your example above, it would look something like this:

<script language="javascript" type="text/javascript" src="../../jQuery%20Libraries/jquery-1.3.2.js"></script>
<script language="javascript" type="text/javascript" src="../../jQuery%20Libraries/jquery.SPServices-0.3.1.min.js"></script>
<script language="javascript" type="text/javascript">
  $(document).ready(function() {
    $().SPServices.SPCascadeDropdowns({
      relationshipList: "States",
      relationshipListParentColumn: "Country",
      relationshipListChildColumn: "Title",
      parentColumn: "Country",
      childColumn: "State"
    });
  });
</script>

M.

---

Marc D Anderson - Sympraxis Consulting LLC - Marc D Anderson's Blog - @sympmarc