I want to create a dashboard that will let me dynamically display data that appears in different web parts but shares a common element.
What I mean is- an master Project List's "Name" value = the project title.
Related lists like Tasks, Notes and Document library will all share a site column (lookup)called "Associated Project" that pulls the Project Title to which their respective items, document etc. apply.
I want to add web parts for all these site elements to a "dashboard" page, then use a Filter web part to allow the user to select the title of the desired project which will then cause ONLY the tasks, document, notes, whatever- which share that Project Title field to appear in their respective web parts.
Please let me know if this is poosible, or is there a better way?