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.

2 Answers 2


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 Feb 10, 2010 at 21:58
  • I'm surprised more custom fields are not defined. There are some great possibilities here, particularly with lookups. Feb 10, 2010 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, 2010 at 9:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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