Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I would like to build a Sharepoint 2010 list that pulls in data looked up automatically from another list on the same site.

In SQL this would be "select List1.,List2. from List1, List2where List1.userid=List2.userid"

Currently List1 looks like

action, userid,

read user1 edit user1 read user 2

etc..

List2 comprises

userid, Userfirstname, UserSurname

user1 Fred Smith user2 Joe Bloggs

I want to build View ActionReports as follows

action, userid, LookedUpFirstname, LookedUpSurname.
read user1 Fred Smith edit user1 Fred Smith read user2 Joe Bloggs

etc....

Or even concatenate the last two together....

Oh & then use it with ClientContext for an external app too

Many thanks

Richard

share|improve this question

1 Answer 1

Just use lookup columns for your first question: Lookup Columns and to join them either use SP.Services, REST API or the Client Object Model.

I would like to give a more precise answer if you give us some more information or some sample code.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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