I have a list with a lookup columns that references another list. This list, in turn, has a lookup column that references a third list. This represents a Child->Parent->Grandparent relationship. I have a view of the child list and
I want to filter the items based on a column in the grandparent list. I know I can do this in code using LINQ to SharePoint, but is there a no-code solution? The Content Query web part infers that it can do this but I didn't see a way to implement this.
Does anyone know of a way to accomplish this in SharePoint Designer or the SharePoint UI?
View Complete Post