Întrebare 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 Field

    List 2 - people
    -----
    person - User/Group AD Lookup
    team - drop down

    I 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:17
     
     
    Is 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:51
     
     
    Any feedback on this issue?