SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

Your Answer


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.