Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have two lists, Activities and Objectives. The Activities list has a multi-value lookup field that references the Objectives list.

I am trying to create a filtered view on the Objectives list that, given a particular Activities item Id, only shows the Objectives that are referenced in that Activities list item's lookup field. I would prefer a solution that can be implemented via SharePoint designer but a custom code solution would work as well.

share|improve this question
    
This might be better served the other way around. Have a lookup in Objectives to Activities, then you can filter the Objectives list easy enough. Otherwise, I don't think this would be doable without some serious development and basically recreating the list view. –  David Lozzi Apr 22 '13 at 15:55
    
Unfortunately objectives can be referenced by multiple activities. –  Chloraphil Apr 22 '13 at 16:45
add comment

1 Answer

Use a workflow which is triggered on the Activities list which inserts the ID of the Activity into a field on the selected objectives.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.