Table Connections and Connection Roles View

[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!

[dpoggemann · Accepted solution]

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.

[tbadger]

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!