Table Connections and Connection Roles View

Like (0) Share

Report

Posted on 18 Feb 2022 04:52:39 by tbadger

Hi,

I am building an inventory app and am attempting to connect products with associated products. I tried a many to many relationship but when viewing related records it only showed the related items from the product I originally made the connection from (if I navigated to the associated product and then to related records it was blank).

In order to get around this, I have created a Connection Role in my solution successfully and it works (if I choose related connections for either of the related products it shows the other related products). However, when viewing "related connections" on a form, I would like to customize the "Active Connection Associated View" to show more than just the Primary Name Column (see example screenshot below). I cannot seem to find this view anywhere. Any suggestions on where to look? It seems to be a system table?

Thanks!

Categories:

Microsoft Dataverse

Tables

All responses (2)

Answers (1)

tbadger 10 on 18 Feb 2022 at 16:23:05

Like (1)

Report

Re: Table Connections and Connection Roles View

Thanks Drew! Problem was I could not find the Connection table even when selecting all tables in my solution. Turns out I needed to add the table to my solution first. Thanks for the reply!
Verified answer

Drew Poggemann 9,278 Most Valuable Professional on 18 Feb 2022 at 10:30:50

Like (1)

Report

Re: Table Connections and Connection Roles View

Hi @tbadger ,

This is under the Connection table in the views. If you don't see this in your list, make sure you change the filter to show "All" tables.

This is a shared view across any Connection so I would suggest to create a new view to utilize for your specific connection relationship and then you can select "Related" under the Table Columns to modify and add your specific columns from your tables.