In many scenarios, we SharePoint developers want to take two different lists and join them and present a single set of data. For instance, one list contains customer information and the other list contains products with serial numbers and customer-related specific details like connection information and versions. There is a lookup field in the product list that selects the customer the product belongs to. So far so good. Now, some silly manager would like to see a single report of all customers... [More]