How to create a lookup to a 'multiple lines of text' column in SharePoint

Posted on 2011-09-26
Medium Priority
Last Modified: 2012-05-12
I don't know of a way this can be done but thought I would throw it out there regardless...is there a way this can be done?  
Question by:nysupport
1 Comment
LVL 14

Accepted Solution

abhitrig earned 2000 total points
ID: 36712300
Not out of the box. Lookup to multiple lines of text is not a good idea.. think how your dropdown will look like with several lines of text.

-If you are 2010 server, use infopath to select the list item (based on some simple filed) and show the details(multiple lines) on selection change.
-Create a wokflow/event handler that sets a field based on the first few words and then create a lookup on that column. Users can then click on the lookup link to see all the text if they want

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question