O'Reilly logo

Microsoft SharePoint 2010 Unleashed by Michael Noel, Colin Spence

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

Creating an External Content Type for a Related Item

Most normalized databases have several tables with relationships to other tables, which are models for real-world information. A customer, for example, can place one or more orders with a company. An order can contain one or more products, and a single order may be delivered in one or more shipments.

A normalized database, to accurately model this information, can define relationships between these tables. A one-to-many relationship would exist between a Customers table and an Orders table. Both tables would contain a CustomerID field. In the Customers table, each individual record would have a unique CustomerID. In the Orders table, there might be several records with the same CustomerID. ...

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