Advanced lookup Custom field

Introduction

The advanced lookup allow adding a lookup from a cross web list and create a infrastructure between the parent and the child list to help navigating.

Add an advanced lookup in a child list

  1. Navigate to your child list
  2. Go to the list administration page
  3. Click on Add a new column
  4. Select the Advanced lookup type
Advanced lookup configuration.png
  1. Choose your list, then click OK

View the result of the related infrastructure

  1. Navigate to your parent list
  2. Go to the list administration page
  3. Look the list columns, two new columns have been created :
    1. The "Related (your child list)" column : It's a reverse lookup column which counts number of (your child list items) attached to a parent list item.
Advanced lookup - related count.gif
  1. The "Related lists" column : It's a custom column which displays all related child lists and their items.
Related Controls.gif
This control allows viewing all related list (you can configure it in the list settings and select related lists to display). When you click on a tab, the related list is display by using ajax calls.
Related Controls-AJAX.gif
You are able to change the layout of the control by applying css :
Related Controls css.gif

How navigating has been configured.

When the advanced lookup column has been added to the child list, a view has also been created with a filter based on the lookup column. This view is used by the Related columns to create the navigating link or to display child items. This view is hidden to prevent an unexpected deletion.

Roadmap

  1. Enhance the advanced lookup field editor control to allow selecting associated column fron the parent list by using the OOTB related feature of a sharepoint feature.
  2. Enhance the advanced lookup field editor control to allow selecting field which will be displayed in the created view.

Last edited Apr 3, 2009 at 11:04 PM by ygo, version 5

Comments

No comments yet.