Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

When creating a lookup column in SharePoint 2007 the user interface restricts the available columns to a subset of all columns in the list. How does SharePoint decide which columns are available?

The accepted answer to this question: Lookup from list column? states that it is only text columns, but that answer is only partially correct as the available selections include the non-text field ID (type Counter), as well as the "Title (linked to item)" option.

Does it add the ID and LinkTitle fields just because it knows they're special?

share|improve this question
add comment

1 Answer 1

I'm not sure this translates to SP2007 100%, but from a SP2010 perspective the following columns will show up when creating a new Lookup field:

SPFieldText, SPFieldDateTime, SPFieldNumber, SPFieldType.Counter (i.e. ID), SPFieldComputed (EnabledLookup property has to be True), and SPFieldCalculated (OutputType property has to be SPFieldType.Text).

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.