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