Editor: SharePoint Cascaded Lookup provides more powerful filter functions to help user to find the look-up item information quickly and exactlyaccurately. Let's take an example by creating a SharePoint Cascaded Lookup Column. Firstly, you can select a filter Filter column which is fromin the look-up list to filter the look-up items. Secondly, you can build a parent-child relationship Between The Filter column and the parent column from the list where you want to build a Cascaded Lookup on it. When editing an item, when youand selecting a choice of the parent column, the look-up choices will be filtered by the selected text of the parent column.
SharePoint Cascaded Lookup can lookup FILTERED columns value from other lists of different sites.
SharePoint default lookup allows users to lookup other list. If column A lookup column B, we call column B as Looked-up Column. When users edit/create an item in the list with lookup column, all the values of Looked-up column will display as choices in lookup column’s dropdown list. To build a parent-child relationship for lookup columns, SharePoint Cascaded Lookup introduces Filter Column and Parent Column to make SharePoint lookup column filtered so as to narrow the range of choices. With this SharePoint cascading lookup tool, you can get filtered lookup column values more quickly and accurately, and build parent-child relationship columns.
Functions:
Cross-site look up SharePoint lists in other sites
Build Parent-Child Relationship by filtering SharePoint columns
Filter looked-up column by Filter Column in the looked-up list
Filter looked-up column by Parent Column in the Cascaded Lookup Column residing list
Two-way conversion to default SharePoint Lookup Column type or SharePoint Cross-Site Lookup Column type
Support filtering multiple-values Cascaded Lookup Column
