• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

Sharepoint - Related Data Between Lists

I have two lists.  A client list and a client project list.  The Client List is a list of all clients and indicates a status of Active or Active.

In the Client Project list I want to show the status from the Client list based on a common field ClientID.  This is not a lookup but more like a calculated field I guess.

Any idea how to accomplish this?

FYI - Sharepoint 2010
0
keschuster
Asked:
keschuster
  • 2
  • 2
1 Solution
 
QPRCommented:
If the clientid in projects is a lookup to the client list you can specify to bring over other columns as part of that lookup. So go to project list settings, click on clientid and choose to include status
0
 
Rainer JeschorCommented:
QPR is right with the additional field selection.
Second approach which only makes sense if you want to show the status just in one or two list views, to add the column dynamically on the client side using either SharePoint Client model Javascript or jQuery and SPServices library.

Third approach would be a custom CAML query using the JOIN feature.

HTH
Rainer
0
 
keschusterAuthor Commented:
Ok I created a lookup that pulls in additional fields.  BUT - the one field I want is not available in the list of additional fields.... what triggers the field to be available in the list?
0
 
QPRCommented:
What kind of column is this status ?
0
 
Rainer JeschorCommented:
Hi,
not all columns are supported as additional field. Perhaps there could be also a bug in SharePoint as well.

Two possible workarounds here:
http://social.msdn.microsoft.com/Forums/en-US/sharepointgeneralprevious/thread/5a80988a-6b37-4454-957b-856ea16b2e60

HTH
Rainer
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now