Insert related list in SharePoint 2010

Introduction: List relationships is a new feature in SharePoint 2010. In this article we will be seeing about the inserted related list in SharePoint 2010.

I have two lists "Departments" and "Employees".

Departments List:

In this list I have the following columns and values.


Employees List:

In this list I have a lookup column "Department" which links to the "Name" field in the "Departments" list. And I have a projected field "Lookup: Manager" which links to the "Manager" field in the "Departments" list.


Inserted Related List:

• Go to the "Departments" list.
• Go to Site Actions => Edit the page.
• Go to the Web Part tools =>Options => Inserted Related List =>Employees.
  
  
  
• Now you could select the value from the "Departments" list and you could be able to see the related Items in Employees list as shown in the following.