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
read user1 edit user1 read user 2
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
Or even concatenate the last two together....
Oh & then use it with ClientContext for an external app too