SP 2010: How To - Relational lists in SharePoint 2010

This article explains the new relational list capabilities in SharePoint 2010, focusing on lookup fields that enforce relationship behaviors. It covers three key features: joins between lists for combining data, projected fields to display parent list information in child list views, and relational integrity options including restricted delete and cascade delete. The article also discusses using the recycle bin to recover deleted related items and provides a step-by-step guide to creating parent and child lists with relationships. Aimed at SharePoint developers and administrators, this technical guide demonstrates how to implement and manage relational data out of the box.