Associations in External Lists

By creating an association between two or more External Lists, you can show columns from another External List. This enables you to create a link between two data sources. A common case for this is a Sales order, with a link to the item you are selling. In this example you create an association between two External Lists, although you can create links between external systems in SharePoint Designer using a standard data source as discussed in Chapter 19.

In the following example, you create a new ECT based on the SalesOrderDetail table in the AdventureWorksLT database and link it to the Product list you created earlier in the chapter. This creates a list with all sales data from your SQL database with a link to ...

Get Microsoft® SharePoint® Designer 2010 Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.