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