Relation List Lookup Issue
-
mardi 17 août 2010 13:46
Hi,
I have 2 lists that are related.
List 1 - costs
-----
cost - Number
quarter - Drop Down
Created By - Default SP FieldList 2 - people
-----
person - User/Group AD Lookup
team - drop downI am trying to link these 2 lists so I can retrieve the users team from the people list in a view for the costs. I have tried making it so the user has manually select their name for each cost (instead of using the Created By field), but when I try to make this value a lookup it doesn't allow me to select the person or team field from the people list? Does a lookup only allow you to lookup text values and is there a work around?
Many Thanks,
Michael
Toutes les réponses
-
mercredi 18 août 2010 05:17Is your Person field in List 2 set to allow only one value or multiple values? I'm not sure it's a valid field to use as a lookup. I'll need to test it, but I wanted you to look at that setting first and set it to allow only one value if it's not already set that way, then go try to make it a lookup.
SharePoint Architect || Microsoft MVP || My Blog
Planet Technologies || SharePoint Task Force -
mercredi 18 août 2010 08:04
Hi Clayton,
It is just a single value person field. So is it correct to say that you can't perform lookups on fields that aren't single lines of text?
Thanks,
Michael -
vendredi 17 septembre 2010 11:51Any feedback on this issue?

