| 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 Edge |
| Mozilla Firefox |
| Google Chrome |
| Supported Languages |
| English |
| Japanese |
| German |
| French |
| Simplified Chinese |