asked on

Lookup Fields in WSS 3.0

Hi,

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

Greg Besso

One option is to create another column on the source list, and attach a workflow on the list that gets triggered each time the list items are modified.
The workflow should take the value of the calculated column and update the value of the new text column field with that calculated value.
Then you can link to that column from other list's lookups.

caratech

ASKER

whoajack:

Your solution does the job, but this means that there will be a additional column visible in the source list when new items are edited.
Is there a way to hide the new field?

ASKER CERTIFIED SOLUTION

Greg Besso

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

caratech

ASKER

Thanks.

I have followed both links and they have provided the help I needed.

Thanks for you help.