Is it possible to look-up anything but single line text values when creating a lookup column?

E.g. I have a list with some general data ind it, one of the columns contains numbers. They should form the basis for a column in another list, but when I try to create the lookup, I can't select the column in question.


It filters the column list down to just the text fields. You can probably define a custom field type that may be able to overcome this.

  • yep it smells like a custom field type – Anders Rask Feb 10 '10 at 21:58
  • I'm surprised more custom fields are not defined. There are some great possibilities here, particularly with lookups. – Mike Oryszak Feb 10 '10 at 22:32

You could create an event receiver on the lookup list that copies the numberic values (OnItemAdded, OnItemUpdated) in its string representation into a text field which you can use for your lookup.

  • I was looking for a solution thats doable by super users but it doesn't seem plausible in this case – noesgard Feb 11 '10 at 9:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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