View Image

SharePoint Cascaded Lookup is a powerful look-up tool that greatly enhances the lookup functionality already native to SharePoint. It quickly cross-references existing data from a list or site within the same site collection and then applies a combination of filters to reduce the number of options presented in the dropdown menu of your lookup field. To use it, you set a combination of filters available in both the source list (the list you are looking up from) and the target list (the list where you want to add looked-up information) to ensure that only applicable values are displayed as choices in the dropdown list.

Filter Column is in the same list with the looked-up column. As the name goes, if you set a column as Filter column for the looked-up column, when you edit/create an item, the choices of the cascaded lookup column will be filtered according to the value of the Filter Column.

FEATURES:

Look up and cross-reference information from any SharePoint site in a site collection;
Build parent-child relationships between columns in the same list so that data entered in one field filters the options presented in another;
Use a combination of filter parameters from the source list and the target list to filter the items presented in a lookup field ;
Automatically synchronize data and update items in the target list when changes are made in the source list;
Add multiple selections from the source list to list items in the target list;
Convert between the default SharePoint Lookup column, Cross-Site Lookup column, and Cascaded Lookup column;
Integrated memory function saves Cascaded Lookup settings when converting between different Lookup column types;
Filter lookup items by view.