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.

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

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, in Customer list, select item Brandysoft and click Related Lookup Information in context menu.

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

Navigate to Order list, select item 20080927-0001 and click Related Lookup Information in context menu.

Then the lookup information is displayed as follows:

Real Time Web Analytics