Solved

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

Posted on 2014-04-22
6
448 Views
Last Modified: 2014-04-22
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
Comment
Question by:colonelblue
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 40016344
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
 

Author Comment

by:colonelblue
ID: 40016365
Hello Teylen.
Oddly enough it was just a multiple text field. Shoudn't that work?
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 40016373
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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Author Comment

by:colonelblue
ID: 40016391
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
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 40016454
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
 

Author Closing Comment

by:colonelblue
ID: 40016461
You're awesome.
Thank you!
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SharePoint 2010 - migrate MySites to a new server? 5 61
Sharepoint List View 6 44
Office 365 OneNote, Groups, Sharepoint, and OneDrive 3 72
Sharepoint Online 5 67
If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

730 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