Custom SharePoint Form that displays data from another List

I have a SharePoint task list. Each task in the task list is for a Client, and there is a drop-down on the task entry form to select the client. The drop down开发者_如何学运维 is populated from a Clients list.

Each client has a tier. Tier is a field in the Client list.

What I want to do, is when a Client is selected in a New/Edit/View form from within sharepoint, I want the Tier to display.

I've created a Custom List Form in SharePoint designer, added a row to the form for the tier, but can't figure out how to populate the tier. I don't want it to be a form field, just to display for FYI purposes.

Any help would be appreciated.

PowerForms supports external calls to SP lists or web services and displaying data in your form. It should do what you need.

You could use jQuery to do this. There is a community-driven jQuery Library for SharePoint. The SPCascadeDropdowns function is probably what you need.