I have a list called "Customers" with some colums in it, some are single line of text and others are choice or calculated.
I have another List on which I want to created a Lookup column that get its input from a column called "Customer Type" from the "Customers" list.
When I select "Customers" in [get information from:], and then click on [Get information from:] I don't see the column "Customer Type"...
It only seems to show columns from the "Customers" list that are single line of text..
Any column that is Choice, Calculated or Multiple line of text, don't appear in the selection.
Is this by design?
How can I get round this problem?
Thanks in advance