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
439 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
  • 3
  • 3
6 Comments
 
LVL 50

Expert Comment

by:teylyn
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:
teylyn 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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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:teylyn
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now