O'Reilly logo

Microsoft® SharePoint® Designer 2010 Unleashed by Kathy Hughes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required