Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2788
  • Last Modified:

SharePoint 2013 lookup columns missing fields

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
Montoya
Asked:
Montoya
1 Solution
 
Rainer JeschorCommented:
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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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