SharePoint Connections Help

Posted on 2013-01-16
Last Modified: 2013-08-20
I have 3 lists

List 1 values: - Systems, Guides, Help
List 2 fields: - List1 lookup (Systems, Guides, Help)

Systems: - Intel, Server, Unix
Guides: - Install, Support, Troubheshooting
Help: - FAQ, Doc, Forum

List 3 content stores the data of Intel, Server, Unix etc..

How do I make the 3 lists on a page to talk to one another..

Say if a user selects, System, it will popup Intel, Server, Unix. The user then selects Intel.

It will show the content of Intel.

How can this be done all on 1 page.aspx
Question by:sharepoint2013
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 8
LVL 50
ID: 38785677

sounds as if you want to do cascading drop-downs (if not, please explain some more). These are not out of the box functionality but can be achieved in several ways:

1. Use InfoPath to edit the list form and create data connections for the drop-downs and filter out what you need.

2. Use the SPServices jQuery library developed by Marc Anderson. It's available on Codeplex here:

and the documentation for the cascading dropdowns is in the Docu section here:

Cascading Dropdowns

Let me know which approach you would like to pursue and if you need further detail.

cheers, teylyn

Author Comment

ID: 38786644
Please teach me the  SPServices jQuery + Cascading Dropdowns method as I do not have Infopath installed in my org.

Can you teach me how do I use the spservices for my above 3 lists on a page.aspx?
LVL 50
ID: 38790245

you need to download the jQuery library, then upload it to your server. In the List form you need to reference the jQuery library and add the script to manipulate the drop down fields.

To edit the list form you need SharePoint Designer 2010. If you don't have that, you won't be able to make these changes.

The SPServices site has exhaustive documentation and samples of several scenarios.

cheers, teylyn
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI


Author Comment

ID: 38790408
That's the list form, I'm editing on an .aspx page which I pulled the 3 lists into that.
LVL 50
ID: 38790450
Maybe I have NOT understood what you are trying to do.

From your question:

>> Say if a user selects, System, it will popup Intel, Server, Unix. The user then selects Intel.

>>It will show the content of Intel.

What is Intel? According to your question you have three lists:

Systems: - Intel, Server, Unix
Guides: - Install, Support, Troubheshooting
Help: - FAQ, Doc, Forum

So, if Intel is selected in the Systems list, what exactly do you want to see and where?

Do you want to filter a list view web part? Or are you entering data in another list?

Please provide more detail.

Author Comment

ID: 38790479
filter a list view web part.
LVL 50
ID: 38792235
Could you please provide a bit more information?

>> I have 3 lists
>>List 1 values: - Systems, Guides, Help
>>List 2 fields: - List1 lookup (Systems, Guides, Help)

What is the third list?

What are the fields of the list? Field names, column types?

What do you want to achieve?

If you need help with a problem, please provide as much information as you can, especially if you've already been asked twice for clarification. 5 words is not much to go by.

Author Comment

ID: 38806777
Sure thing! apologies on the insufficient explanation.

Let me repeat.

List 1 values: - Systems, Guides, Help
List 2 values: - Intel, Server, Unix

List 3 fields are: list1_value, list2_value, description

Example of List 3 values are:
- Guides, Intel,       this is the guide of intel
- Guides, Unix,       this is the guide for unix
- Help, Intel,           this is the help file for intel


So now.. I have a page.aspx which allows the user to select a value from List 1 and List 2 and them it will show the description from List 3

How can this be done?

Hope its clear.
LVL 50

Accepted Solution

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 500 total points
ID: 38807814

thank you for this explanation. It makes a lot more sense now. So you have a list with two lookup fields from other list and you want to filter the primary list.

You can do that with out of the box web parts. Create a list view web part for the primary list and two filter web parts of the type "SharePoint List Filter". Link the two list filters to the two respective lists.

Then connect the filter web parts to the list view.

See the screenshots

Connect the web parts


Unfiltered list


Apply the first filter

2filtered list

Apply the second filter

cheers, teylyn

Author Comment

ID: 38808420
where do you get the dropdown filter from?

i'm using SP2007
LVL 50
ID: 38808453
The screenshots are from SharePoint 2010, but filter web parts are available in 2007 if you have the MOSS enterprise edition.

If you don't have that version, there are free solutions available on Codeplex.

Author Comment

ID: 38866724
Do you have code samples for SP2007
LVL 50
ID: 38866749
I don't understand that latest question.

What license of SharePoint 2007 do you have? As I said above, if you have Enterprise, then you will have the filter web parts. If you don't have Enterprise, then you can get the free web parts from Codeplex.

Where do code samples fit in all this?

Author Comment

ID: 38866846
it's Standard.
LVL 50
ID: 38866893
Ok, so that means you don't have filter web parts out of the box. The free (free!!) Codeplex web parts are the way to go.

It may be daunting at first to delve into this, but if you want functionality that is not included in your license, then you'll have to bite the bullet.

Don't shoot the messenger.

Author Comment

ID: 38934496
Will try this out.

Author Closing Comment

ID: 39424045
Awesome solution!

As mentioned above i'm using sp2007 standard and do not have access to central admin to deploy codeplex webparts, how do i create the dropdown list webparts in designer?

Featured Post

Is Your Team Achieving Their Full Potential?

74% of employees feel they are not achieving their full potential. With Linux Academy, not only will you strengthen your team's core competencies but also their knowledge of of the newest IT topics.

With new material every week, we'll make sure that you stay ahead of the game.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article demonstrates how to create a simple responsive confirmation dialog with Ok and Cancel buttons using HTML, CSS, jQuery and Promises
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…
Suggested Courses

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question