Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Sharepoint - Related Data Between Lists

Posted on 2013-06-10
5
300 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
ID: 39236142
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
ID: 39236158
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
ID: 39238043
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
ID: 39239441
What kind of column is this status ?
0
 
LVL 44

Accepted Solution

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Error while setting up the Server Farm Account 8 42
Moving SharePoint 3.0 role to differen server 7 68
VBA in SharePoint 3 50
Icons on a page, side-by-side 6 45
The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

840 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