Cascaded Lookup provides the feature to show related columns for a lookup item, which can make end-users to learn more about the relevant information and easy to locate target item(s).
For showing related columns, Cascaded Lookup provides two views, left to right box and table view.
This article will demonstrate how to display related columns in left to right box view.
The related columns [Expiration date] (12/31/2019) and [Support Type] (Premium) are shown in tooltip in left to right box view.
Then, create the other list named as Orders from the custom list template with following columns and items on the same site collection.
Download the trial version of Cascaded Lookup, and install it to your SharePoint server.
Navigate to the Orders list prepared above, click List tab. In the Manage Views group, click Create Column .
Or go to the List Settings page and click the Create column link in Columns section.
If you already created a Cascaded Lookup column, please skip to step 6.
In the Name and Type section, enter a name in the Column Name field to give it a meaningful name such as Contract, then select Cascaded Lookup as the type of information in this column.
In the Additional Column Settings section, keep all settings as default.
In the General Settings section, configure settings as following.
In the Get information from this site box, select Marketing Center, because in our example the Contracts list is located in a SharePoint site named as Marketing Center. You need to select the corresponding SharePoint site in which your Contracts list is located.
In the From this list box, select Contracts.
In the In this column box, select Name.
And select Allow multiple values checkbox.
In the Appearance section, select Expiration date and Support Type columns as following.
And in Specify a style to display related columns dropdown list, select Left to right box.
Note that the Left to right box is only available when Allow multiple values is selected.
Keep other settings as default and click OK.
And then you will find that a Cascaded Lookup column named as Contract has been added to Orders list as following.
In the Orders list, select order CB-0002 and click Edit Item. And you will see the Contract column as following.
Hover over a lookup item, a tooltip will appear and show the relate columns.
You can double click the item in the left box to add it to the right box; or choose one or more items, and click Add > button to add them to the right box.
Select two lookup items, and click Save button. Then, the multiple lookup items are displayed as following.