SharePoint Connections Help

Hello,

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:

http://spservices.codeplex.com/

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

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?

Hello,

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

That's the list form, I'm editing on an .aspx page which I pulled the 3 lists into that.

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.

filter a list view web part.

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.

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.

where do you get the dropdown filter from?

i'm using SP2007

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.

http://spvisibilityfilter.codeplex.com/

http://dropdownsharepoint.codeplex.com/

Do you have code samples for SP2007

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?

it's Standard.

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.

Will try this out.

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?