• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 456
  • Last Modified:

New list item - related drop downs

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
QPR
Asked:
QPR
  • 4
  • 3
1 Solution
 
sharepointguru14Commented:
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
 
QPRAuthor Commented:
2010, the download and sample seem to indicate 2007
0
 
sharepointguru14Commented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
QPRAuthor Commented:
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
 
sharepointguru14Commented:
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
 
QPRAuthor Commented:
awesome, thanks
I'll install infopath 2010 after my meeting and give it a go
0
 
QPRAuthor Commented:
Works perfect! thanks
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now