Imagine the situation. There are two lists:
- Project ID
- Task ID
- Project (lookup field, linked to the Projects list)
- Assigned (People picker field)
How can we show the list of projects that have tasks assigned to the current user. Is it possible to do this without creating custom WebPart and programming? May be via a specific CAML-Query?