Solved

Sharepoint - Related Data Between Lists

Posted on 2013-06-10
5
272 Views
Last Modified: 2013-07-02
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
Comment
Question by:keschuster
  • 2
  • 2
5 Comments
 
LVL 29

Expert Comment

by:QPR
Comment Utility
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
 
LVL 44

Expert Comment

by:Rainer Jeschor
Comment Utility
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
 

Author Comment

by:keschuster
Comment Utility
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
 
LVL 29

Expert Comment

by:QPR
Comment Utility
What kind of column is this status ?
0
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
Comment Utility
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now