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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
