SharePoint 2007 - When adding a new ( look up field column ) in a custom list I ony see Title, Version, and ID.

Hello Experts,

I have been trying to add a lookup field to a Custom List.
However all I can see to select from the list is the Title, Version, and ID.
I would like to select a different column from the lookup and I had done it before a while back.
Why can't I see the rest of the columns such as this screenshot?
( please forgive I know the image is from a search for answers and is 2010 nevermind the functionality exists on 2007.

Thank you in advance.

Custom List additional Columns
Who is Participating?
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Nope, multi-line text fields don't work in lookups. See the following screenshot. On the left, with a white background you see the columns in a list called "Sample Data". On the right, with the grey background I have the definition for a lookup column into that list.

The screenshot is from SharePoint 2010, but I think the same applies to 2007.

So, sorry, but no, it cannot be done with that data type.
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

a lookup column can not return all data types. For example, it does not return choice columns, managed metadata columns, calculated columns or person/group columns. That's why you may not see the column you are after.  What data type is it?

cheers, teylyn
colonelblueAuthor Commented:
Hello Teylen.
Oddly enough it was just a multiple text field. Shoudn't that work?
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

colonelblueAuthor Commented:
Aaahh! :) OK I got the fields to show,
Only thing is why am I getting a dropdown box to select a column and not a few checkboxes like in the image above?

Because I cannot use multi-line text-boxes, I will have to use several columns.
For example I want to use 4 lines of a Company's info (Name, address, City, State)
Now I will need to use a single text box for each instead ofone just one multi-text box.
The client wants a dropdown to show a selected Company's contact info .

I'm sorry maybe not clear enough.
Instead of the company name with a hyperlink to the detail page they wanted the company name and address to show when that company is selected from the dropdown box and why I was trying to use a lookup to a multiple text box.
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
The screenshot has been taken with SharePoint 2010. In 2007 you cannot select multiple columns from a lookup list. That functionality is new to SharePoint 2010.  In 2007 you can only select one column from a lookup list.
colonelblueAuthor Commented:
You're awesome.
Thank you!
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.

All Courses

From novice to tech pro — start learning today.