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

Get Microsoft SharePoint 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.