<div>
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
</div>


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

<div>
QPR is right with the additional field selection.<br />
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.<br />
<br />
Third approach would be a custom CAML query using the JOIN feature.<br />
<br />
HTH<br />
Rainer
</div>


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

<div>
Ok I created a lookup that pulls in additional fields. &nbsp;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?
</div>


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?

<div>
What kind of column is this status ?
</div>


<div>
<div class="content wysiwyg-content">
I have two lists. &nbsp;A client list and a client project list. &nbsp;The Client List is a list of all clients and indicates a status of Active or Active.<br />
<br />
In the Client Project list I want to show the status from the Client list based on a common field ClientID. &nbsp;This is not a lookup but more like a calculated field I guess.<br />
<br />
Any idea how to accomplish this?<br />
<br />
FYI - Sharepoint 2010
</div>
</div>


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

Sharepoint - Related Data Between Lists

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.