• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 452
  • Last Modified:

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
0
colonelblue
Asked:
colonelblue
  • 3
  • 3
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

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
0
 
colonelblueAuthor Commented:
Hello Teylen.
Oddly enough it was just a multiple text field. Shoudn't that work?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)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.

screenshot
So, sorry, but no, it cannot be done with that data type.
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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.
0
 
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.
0
 
colonelblueAuthor Commented:
You're awesome.
Thank you!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now