BoostSolutions

1. Introduction

SharePoint Lookup Tracker is a tool to summarize all information related to an item in a list. It provides a page to display not only all items one item looks up from, but also all items which look up information from this item. A "Related Information" link displays all connected information on the item.

2. How does this work?

  • Sample scenario:
  • There are three lists in the site: Customer, Sales, and Order.
  • "Customer" list has two Lookup columns named "Sales" and "Order.No".
  • "Sales" list has one Lookup column named "Order.No".
  • "Order" list has two Lookup columns named "Customer" and "Sales".

In "Customer" List, column "Sales" looks up information from column "Saler" of "Sales" list, and column "Order.No" looks up information from column "No." of Order list.

In "Sales" list, column "Order.No" looks up information from column "No." of "Order".

In "Order" list, column "Customer" looks up information from column "Customer" of "Customer" list, and column "Sales" looks up information from column "Saler" of "Sales" list.

Now, look at "Related information" of item "Brandysoft" in "Customer" list. All related information is displayed in one page, including all items from which this item looks up, and all items which look up information from this item.

And in "Related information" page of item "20080927/0001" in the Order list, the lookup information is displayed as follows:

Real Time Web Analytics