Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

New list item - related drop downs

Posted on 2011-03-21
7
Medium Priority
?
448 Views
Last Modified: 2012-05-11
I have 3 lists that have lookup columns related to each other.
Location, building, room
Buildings have a lookup to location
Rooms have a lookup to buildings

How can I restrict the buildings in the drop down based on the location selected in the previous drop down (and then again with rooms?)
0
Comment
Question by:QPR
[X]
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
  • 4
  • 3
7 Comments
 
LVL 15

Expert Comment

by:sharepointguru14
ID: 35185553
Natively out of the box with sharepoint....I don't know of any way. What version of SharePoint are you using?

To answer the question though, you can do it by creating a custom field control. Good walkthrough with code samples on how to create your own can be found here:
http://datacogs.com/datablogs/archive/2007/08/26/641.aspx

Or you can just download one that should work for you here:
http://customfieldcontrols.codeplex.com/
0
 
LVL 29

Author Comment

by:QPR
ID: 35185590
2010, the download and sample seem to indicate 2007
0
 
LVL 15

Accepted Solution

by:
sharepointguru14 earned 2000 total points
ID: 35185680
yep they are 2007 related I took a guess since this was a big problem with 07. In 2010 we can use InfoPath which gives us a no code solution. Below you can find 2 links that do a nice just of walking you through the process and explaining it along the way.

http://basquang.wordpress.com/2010/03/29/cascading-drop-down-list-in-sharepoint-2010-using-infopath-2010/

http://blogs.msdn.com/b/infopath/archive/2004/03/24/95529.aspx?wa=wsignin1.0
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 29

Author Comment

by:QPR
ID: 35185762
Looks perfect... but when I click the customise form button it tells me I need infopath 2010 installed.
This I can do. But when this site is delivered will the user adding the new item also be expected to have infopath 2010 on their client or will the logic for the cascading drop downs be copied to the server somewhere?
0
 
LVL 15

Expert Comment

by:sharepointguru14
ID: 35185784
you need infopath to actually use the form designer to make the changes to the form. Users will not need the infopath client as the solutions at the links provided will work with browser based forms so they will click and it will open in the browser. no client needed.
0
 
LVL 29

Author Comment

by:QPR
ID: 35185800
awesome, thanks
I'll install infopath 2010 after my meeting and give it a go
0
 
LVL 29

Author Closing Comment

by:QPR
ID: 35186446
Works perfect! thanks
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

705 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