Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Filtering items in a dropdown based on a selection in another dropdown

  Asked By: Dominique    Date: Jan 29    Category: Sharepoint    Views: 8188

if the heading was vague/long but here is what I'm trying to find out.

I'm trying to create a list where, when a user creates a new item, he can choose
from two dropdowns. When he makes a selection in the first dropdown, the values
available in the second drop down are filtered based on the first selection.

Does anyone know how this can be done?



5 Answers Found

Answer #1    Answered By: Deirdre Macias     Answered On: Jan 29

reating custom columns (also called custom field types or CFTs) is the
best practice (as opposed to creating a custom data entry form). Once the CFTs
are created and deployed, it can be reused anywhere,

Heres a link for what you need:
http:// datacogs.com/ datablogs/ archive/2007 /08/26/641.aspx

Answer #2    Answered By: Kala Solomon     Answered On: Jan 29

There is no out of the box solution.

There are few ways using xslt or coding. If you search using "cascaded drop  down
in sharepoint list" you will get right links to achieve your requirement.

Answer #3    Answered By: Madison Clark     Answered On: Jan 29

It's possible that a third-party relational dropdownlist control might do
this for you; the only issue is whether it can be bound to a SharePoint

Answer #4    Answered By: Dhanraj Saxsena     Answered On: Jan 29

I literally just did this yesterday!

Check this out:

So, it's jQuery and they use the SP Web Services model to get data from other
lists. In particular I used this:

I'm not certain of its reach outside of a Site Collection. The example they use
has three different lists, however, I used the same list  with three lookup
columns. The first lookup column populated the next two based  on their reference
to the first. Read it and you'll understand a little better. If you have any
questions just post them up here and we'll try to help

Answer #5    Answered By: Kacie Calhoun     Answered On: Jan 29

You may have to use cascading dropdown  functionality to achieve this. Is the
data for these 2 dropdowns  coming from 2 different lists? If so, make sure
you include look up columns appropriately. The following link might help you
achieve this using jQuery.