From the course: SharePoint Designer 2010: Creating Data-Driven Web Pages

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Creating associations in Business Connectivity Services

Creating associations in Business Connectivity Services - SharePoint Tutorial

From the course: SharePoint Designer 2010: Creating Data-Driven Web Pages

Start my 1-month free trial

Creating associations in Business Connectivity Services

Very often the external data that you're working with has a dependency on something else, a relationship to something else on that external system. For example, I am viewing some information here about titles. This is coming from an external content type, and I see that I have a pub_id column. This is really just a reference, a relationship to a publisher's table on that same database. This isn't all that important when we're just reading some of this data, but when we're inserting information, it's doubly important. We really need to understand more about what this means. If I'm entering a new item here, I need to know what pub_id to put. And if I get this wrong, the database won't even let me insert it, based on the internal rules of the database. Now, while that relationship might be defined in the database itself, we haven't told SharePoint about it, and SharePoint will not automatically understand that relationship until we tell it to. So here's how we do this. I am going to jump…

Contents