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.

In the Name and Type section, enter a name in the Column Name field to give it a meaningful name such as Customer, 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 Customer list is located in a SharePoint site named as Marketing Center. You need to select the corresponding SharePoint site in which your Customer list is located.

In the From this list box, select Customer.

In the In this column box, select Customer.

In the Additional Fields section, select Contact and Contact Email columns.

Keep other settings as default and click OK.

And then you will find out that Customer : Contact Email and Customer : Contact columns are created in the Orders list.

In the Orders list, select CA-0001 and select Diff Inc in Customer column. And then the additional fields are shown in the list view as following.

When you click the item CA-0001 to view the details, the additional fields are also shown as following.