I'm still new to sharepoint and would like to know if it is possible to make a query that works across multiple lists. My list is as follows
Customers (id, name, etc.) Orders (identifier, order number, customer and additional information) OrderItems (id, name, price, description, etc.)
I would like to create a view that displays OrderItems grouped by order, which will again be grouped by the Client.
In pure .net code, which is pretty simple, but is it possible to implement it only using sharepoint lists?
source
share