Sharepoint 2007 - When use Lookup Columns instead Choice Columns
There are a number of ways to store options for a field that requires a group of pre-selected options, a drop down list as it were. I always thought that defining a column of the type choice is the way to go but recently discovered that in a couple of areas that creating a list and then using that as a look up is actually a better solution. When to use a Choice Column You should use a choice column, pictured below, in the following circumstances: 1) Only site administrators should be able to add/remove/edit options 2) You don’t have that many options to choose from (maximum ten) and users will usually only select at most 5 options. 3) The options rarely change This is the usual way to go in a SharePoint environment but it can cause many issues. For starters a choice column can only store 255 characters (SharePoint in built field limit) so if your users are choosing 10 options each of 26 characters (see below) then they wont be able to. This is because the choice fied...