mobrien118
asked on
SHould I use a lookup for my column or choice?
Hi,
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!!!
--mobrien
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!!!
--mobrien
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER