SHould I use a lookup for my column or choice?

Posted on 2008-04-08
Last Modified: 2011-04-14

I'm going to create a column to be used in a new project workspace template for issues (and one for risks too). I want to have a column to select the business unit and I think it would work to have a sharepoint list of the business units, which could include a description field and be used for other stuff too.

My questions:

Should I do this and use it as a lookup column? It seems like the benefit would be that I could allow admins to modify the table and if the business structure changes, all they would have to do is change the lookup table.

Can it be used on subsites, or it is constrained to the site where it is created? (Don't really see this as being a problem, but just asking).

Are there any downsides to doing this? It seems pretty intuitive.

If there is a URL of someone out there with an answer to this or a comparison I will accept that as a solution (as long as it fully answers the question and clearly).

Thanks in advance!!!


Question by:mobrien118
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

Accepted Solution

moss_guru earned 500 total points
ID: 21323870
A site column is restricted to the site only, not the site collection.  The two best ways to do this are

1) Create a list and make the column do a lookup.  This is best especially if you will have frequent changes to the list. The only major downside is that there is now one more list on your site.

2) create a multiple choice column and populated it with the correct options.  This is better for a list that will not be changed often, as it is self-contained, and doesn't require another list "cluttering up" the site.  I believe there is also a minor performance gain, as the column definition contains the possible values and an additional query to another list is not required.  I don't think that would normally be noticeable, however, unless you had a lot of choices in the list.

Author Closing Comment

ID: 31447229
Thanks for the input. Good answer.

Expert Comment

ID: 22744180
There is more to this than the two best ways to create the site column.  Potential gotchas are:  a lookup cannot be used as a formula in a calculated field.  A lookup cannot be accessed in "edit in datasheet" mode.  I'm sure there are more; this thread would be a great place to keep track of them as community members find them.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

696 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