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:

SharePoint Online

The cloud parts are functional components that extend your SharePoint Online environment in Microsoft 365.

Supports Classic and Modern sites for SharePoint Online/Microsoft 365


Top SharePoint Online Products

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

Calendar Plus

Chart Plus

Knowledge Base

Project Management Central

Simple List Search


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 – Classic Pages Only


Top On-Premises Only Products

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

Calendar Plus

Data Viewer

Password Change

Password Expiration

Password Reset


Our team of Microsoft 365 experts help you get the most out of your Microsoft technology, we have the best Microsoft 365 talent to streamline your organization.

Streamline Your Department

We Have What You Need

Bamboo Solutions



Webinar & Events


Culture & Diversity



Bamboo Solutions



Bamboo Installer


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!