How to use Multiple lines of text as lookup field in other List

Question

_{Monday, January 30, 2012 11:08 PM}

Hi Everybody,

I am trying to use Multiple lines of text type field in other list as lookup field and it doesn't show me this field as lookup.

Thanks in advance.

CRP

All replies (2)

_{Tuesday, January 31, 2012 12:51 AM ✅Answered}

It wont. The lookup field works on a key value pair to identify the correct value. If you use a multiple lines of text column, it is just a variable of type string in the database. Therefore a lookup can never work with it.

What is the requirement anyway?

- Sid

_{Friday, May 29, 2015 6:23 PM}

The requirement would be the same as when you need any relational database structure.  I.e. you have some data you don't want to duplicate in one table so you move it to another table and point to it.