Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

In SP2010,

I want to get 2 columns from another list and merge these columns. But when I am trying to do this via Lookup, they are not shown under "Add a column to show each of these additional fields".

But when I tried a simple text one (not lookup) it is shown.

Is there anyway to show a column which a kind of lookup field?

share|improve this question
add comment

4 Answers 4

up vote 9 down vote accepted

I gather that you're trying to use a lookup to 'bring in' additional fields to your current list, but that they aren't available to select.

Some field types are not available for this sort of function. For example, further Lookup fields can't be brought in.

Also, notably and annoying, neither can Choice fields. This was possible in SharePoint 2010 before SP1, but after SP1 it seems to be no longer possible. I can't see a good reason why, and it is very annoying.

There is no way of making additional types of column available in the look up control as far as I know.

share|improve this answer
    
thanks Andy, i googled it alot and there is really no way to use looked up columns in additional fields. Its bad :/ I must find another way. –  alicanbatur Jun 27 '12 at 10:44
1  
+1 for the note on choice fields. Apparently a workaround is to copy the choice field to a calculated column –  Christophe Aug 29 '13 at 22:57
add comment

Not all fields are supported as lookup fields. I tried to find a supported fields list but didn't find one. While searching though I ran across this discussion which offers a fix for columns that aren't supported such as choice fields.

http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/5a80988a-6b37-4454-957b-856ea16b2e60

share|improve this answer
add comment

I found a work around for this, what you do is use a wf to move the column into a text field. Go the origional list that has the information you'd like to look up. Creat a new text column and give it a name similar to the one you would like to dupilicate. Then create a WF to auto-populate that column into a text field. You can then look that column up in any other list.

share|improve this answer
    
Yeah, this is what we do as well. –  PeterX May 22 '13 at 6:15
add comment

Not as far as I know - which is why it doesn't show.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.