SharePoint List Field Lookup Filtering in SharePoint Designer 2010, without using InfoPath 2010.

Question

Hi all,

I am using SharePoint Standard where I am not able to work in InfoPath.

I want to filter my one of SharePoint Lookup List Field.

I have one list say List-1

Fields:

Product Name, Supplier both are single line text field.

I have one more list say List-2

Fields:

Product Name, Supplier both are lookup field getting data from List-1 Product Name and Supplier respectively.

Now I want to filter the data in List-2 Edit Form when I Select Product Name only those supplier I want that I mentioned in List-1 Supplier Field.

Example Scenario:

List-1:

Product Name	Supplier
P1	S1
P2	S2
P3	S1
P4	S2
P5	S3

In List-2 edit form If I select Product Name P1 in lookup then I want only S1 option in Supplier Lookup not all.

Can anyone help me for this..

Thanks in Advance,

---

Faheem Ahamed

Answer 1

This is called a Cascading drop down. If you use that search term with SharePoint you will find a lot of resources on how to do this. here is a project I found on Codeplex as an example.

http://cascddlistwithfilter.codeplex.com/

A lot of people have done this and posted on it, so you should be able to find some good advice pretty easily.

Answer 2

Hi,

I'd suggest this method http://sharepointjavascript.wordpress.com/2010/06/15/cascading-dropdowns-in-sharepoint-text-fields-populated-by-lookup-in-another-list-version-2/  as addition to Bill.

You can find on that site few other versions, and many useful articles.

Cheers,