Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word

3.5. Creating Master-Detail Relationships Between Your Lists

One of the more interesting things you can do with lists is to define master-detail relationships between two or more lists. A master-detail relationship between lists looks a lot like the parent-child relationship between tables in a database. Basically, it means that a list designated as the master has items that relate to one or more items in a second list called the detail list.

One example of a master-detail relationship might involve a list of the departments in your organization. Since departments consist of one or more staff members, you might build a detail list of staff and include their names, titles, telephone extensions, and related information.

Another example might list ...