O'Reilly logo

Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word by Michael P. Antonovich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required