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

Can a SharePoint 2010 lookup column point to a multi-line rich text field in another list? From what I'm reading, it can only see single-line text fields in the other list, which limits its use in our case.

What we need to do is pull a rich text field from another list and show it in the first list, but filter it somehow. So a certain item in List 1 will show a rich text value from List2. If you know of another way to do this, we'll use that instead.

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

No, not that I've seen even in 2007. There are 2 options that I can see.

Use a lookup column (point to the title field or something similar) and a workflow on item creation that pulls the data from the associated lookup list that copies the rich text field into it's own rich text field.

Or just use a lookup field (point to the title field or something similar) and use a linked datasource and a dataview web part with joined subviews to display the data.

The second option would be "better" in that you aren't duplicating content and you don't have to worry about trying to keep data in sync. Marc Anderson has a good post on joined subviews in DVWPs.

share|improve this answer
    
Thanks, PirateEric. Is there an example for the second option or something that comes close? What is a lookup "field"? The point of the lookup column was to eliminate redundancy, so that's the one we'd want to use -- if we can figure it out :) –  Alex C Dec 12 '11 at 15:09
1  
I was using lookup column/field interchangeably. Updated question to point you to a resource on joined subviews. –  PirateEric Dec 12 '11 at 15:18
1  
You could also add a custom Event Receiver where you can control what text gets copied over and also do some string manipulation. –  Fox Dec 13 '11 at 6:24
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.