Create an Association Between External Content Types for BDC Configuration Using SharePoint Designer 2013, Part 3 of 4: Creating an Association Between External Content Types

Part 3: Creating an Association between External Content Types for BDC

In Part 3 of our series on creating a model for the BDC service that returns information about contacts in a sample database, we will walk through the process of creating an association between External Content Types for BDC through SharePoint Designer 2013.

Step 1: Right-click on the second table which was created in Part 2 and select the New Association menu:

If desired, rename the Association Name or Association Display Name.  Once complete, click the Browse button to select the Parent table (which the second table needs to refer to):


Next, select the reference field for the right combo box for the appropriate option.

Click Next to continue.

Step 2: Select the reference key and check on the Map to Identifier checkbox as pictured in the example below:


Click Next to continue.

Step 3:  To complete the process, click Save in SharePoint Designer:

At this point, you should have two tables (parent table and child table) displayed on the pane on the left side of the program.

Upon completing the above steps, verify that your BDC services configuration was successful going to Central Administration -> Application Management -> Manage service applications -> Business Data Connectivity Service.

Check out the rest of the series here:

All SharePoint Versions

The web parts are functional components that extend your SharePoint environment whether it’s hosted, on-premises, or part of Microsoft® Office 365.

SharePoint 2013, 2016, 2019, Online (Office 365)

On-Premises Only

These web parts extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of SharePoint Web Parts.

SharePoint 2013, 2016, 2019


Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.

Essentials Suite

Essentials Plus Suite

Bamboo Premier Suite

Project Management Suite

Knowledge Management Suite

External User Manager


For more information on our product suites, contact us.

Featured Services

SharePoint Health Check

A SharePoint Health Check will identify the causes of issues and risks associated with your specific environment, and is custom tailored to provide you with the best recommendations to optimize your SharePoint environment.

SQL Health Check

Document recommendations relating to performance, stability, availability, or a specific focus you request of your SQL Server database instances.

My SharePointXperts

The truth is that each SharePoint skill may not be a full time job for many organizations, and it is nearly impossible for one person to do everything you need – so augment your team with SharePointXperts; providing the skill sets you need when you need them!