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.

1 Answer 1


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.

  • 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, 2011 at 15:09
  • 1
    I was using lookup column/field interchangeably. Updated question to point you to a resource on joined subviews. Dec 12, 2011 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, 2011 at 6:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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