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.