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

Small Business Pricing and Discounts

SharePoint

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 2016, 2019, 2022 - Classic Pages Only

SharePoint

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

M365 Plus

Managed Services

We Have What You Need

Federal Contractors