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.

  • 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. Commented Apr 22, 2013 at 15:55
  • Unfortunately objectives can be referenced by multiple activities.
    – Chloraphil
    Commented Apr 22, 2013 at 16:45

1 Answer 1


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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