R – Using fields from a ‘lookup-ed’ sharepoint list

sharepointsharepoint-2007

I have two Sharepoint lists:
– Assignments
– Activities

The activities list has a lookup field to the assignments list as activities (e.g. monthly review of X) are related to an assignment.

My question is, how would I display other fields from Assignments in a view of Activities using standard Sharepoint 2007 (we have restrictions on using SP Designer or Visual Studio as it is a 'standard' corporate environment)?

E.x.

Assignments

Assignment    Frequency    Area       Assigned To 
Read X        Monthly      Finance    Bill

Activities

Assignment    Date        Action
Read X        2-Mar-08    No actions needed
Read X        3-Apr-08    Adjust Y

Desired SharePoint List (to view/sort/filter)

Assignment    Frequency    Area       Assigned To    Date        Action
Read X        Monthly      Finance    Bill           2-Mar-08    No actions needed
Read X        Monthly      Finance    Bill           3-Apr-08    Adjust Y

Best Answer

If you can't use the Data View Web Part from SPD, then I think you are going to have to use a content editor webpart and do this all in javascript. intro article

Related Topic