Solved

SharePoint 2013 lookup columns missing fields

Posted on 2013-11-19
1
2,126 Views
Last Modified: 2013-11-20
I have two lists:

List1:

Contractor (people picker)
number (text)
dept (text)

List2:

PO Number (text)
Contractor (lookup) -------> This lookup will let me pick ID, Created, number, dept, etc... but there is NO choice for Contractor. I tried creating a second people picker column in list1... and it omits them both.

Help please!

Montoya
0
Comment
Question by:Montoya
1 Comment
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 39662764
Hi,
unfortunately not all column types are available to be used as lookup fields.
An overview can be found here:
http://office.microsoft.com/en-us/sharepoint-help/create-list-relationships-by-using-unique-and-lookup-columns-HA102771358.aspx

The following table summarizes what column types can and cannot be used to create lookup columns.
Supported Column Types:
Single line of text, Multiple lines of text, Choice, Number, Date and Time, Yes/No

Unsupported Column Types:
Currency, Lookup, Person or Group, Calculated, Hyperlink or Picture, Custom Columns

HTH
Rainer
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

776 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