• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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