Microsoft SharePoint 2010 Unleashed

Working with Lookup Columns in Document Libraries

This next exercise uses two standard lists in a SharePoint 2010 Team Site: the Calendar list and the Tasks list. The goal of this example is to show the basic capabilities of the lookup column using a business example where a department tracks tasks using a Tasks list, and has weekly meetings that are managed in the Calendar list. The manager wants to use SharePoint to make the meeting more productive and wants to use the lookup column to pull additional information from the Tasks list into the Calendar list.

Consider the possibility that the Tasks list might have different permissions configured than the Calendar list. For example, on this site, the administrator may only allow project managers ...