Product Features

Create parent-child, cascading relationships between columns so data entered in one field filters the options present in another

Unlimited number of cascading levels

Filter and sort retrieved data by selected view

Filter retrieved data by one or multiple columns from the target list

Support filtering by multiple values in cascading function

Supports cross-site lookup to reference list from any site within a site collection

Supports autocomplete, find-as-you-type functionality to easily search retrieved data

Automatically create a reverse lookup field in the target list

Allows users to create a reverse lookup field using an existing Cascaded Lookup column in the target list

Supports four display styles: dropdown list, left <-> right box, table (grid) view and item picker

Display relevant columns from the target list alongside lookup values in table view on Item View/Edit form; allows paging, filtering, sorting (for multiple values)

Display relevant columns from the target list alongside lookup values delimited by semicolons in ”left <-> right box” on Item View/Edit form; tooltips supported (for multiple values)

Display relevant columns from the target list alongside lookup values delimited by semicolons in dropdown list on Item View/Edit form; tooltips supported (for single value)

Cascaded Lookup column is usable for calculation when creating a Calculated column

Add new items to the target list via “Create new item…” link; supports access control over this link

Supported column types: Single line of text, Number, Date and Time, Calculated (output is single line of text), system reserved fields ( such as ID, Created, Modified and Version)

Supports referencing values from document “Name” column; ability to download a copy directly by clicking the file name on Item View form

Display Cascaded Lookup columns with icons

Add additional or secondary fields from the target list to display in the view of the source list

Allows users to change the order of the additional fields on the Change Column Ordering page

Set a default value for lookup column; supports custom value as default value

Option to display empty field when no items match the filter criteria

Automatic duplicate removal (display only one instance when duplicate items exist)

Option to remove the link of Cascaded Lookup columns in list view and View item form

Auto adjust the width of the Cascaded Lookup control according to value length

Supports Cascaded Lookup column as a site column

Convert an existing SharePoint lookup column to Cascaded Lookup column

Convert Cascaded Lookup column to SharePoint lookup column

Export Cascaded Lookup column data to Microsoft Excel

Export Cascaded Lookup column data to Microsoft Access database

Manage Cascaded Lookup column data in Microsoft Word

Sync Cascaded Lookup column data to SharePoint Workspace

Supported Environments

Microsoft SharePoint Server Subscription Edition

Microsoft SharePoint Server 2019

Microsoft SharePoint Server 2016

Microsoft SharePoint Foundation 2013

Microsoft SharePoint Server 2013

Supported Browsers

Microsoft Internet Explorer 8/9/10/11

Microsoft Edge

Mozilla Firefox

Google Chrome

Supported Languages

English

Japanese

German

French

Simplified Chinese