colonelblue
asked on
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.
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.
ASKER
Hello Teylen.
Oddly enough it was just a multiple text field. Shoudn't that work?
Oddly enough it was just a multiple text field. Shoudn't that work?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
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.
ASKER
You're awesome.
Thank you!
Thank you!
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