Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / Two relations for sub ...
Service | Customer Service, Contact Center, Fie...
Suggested answer

Two relations for sub grid

(0) ShareShare
ReportReport
Posted on by Dy365Fan

In Dynamics you can only select one relationship in the subgrid for one table. Is there a way to customize the subgrid with your own query?

I would like to show all related records based on two relations from one table.

Example: selected contact = ‘Peter’ has two relations to table "connections"

Result should show all records where column A =’ Peter’ or column B = ‘Peter’

 query example:

SELECT *

FROM Contact
WHERE Column A = Peter
OR Column B = Peter

  • Bassey Profile Picture
    Bassey 9 on at
    RE: Two relations for sub grid

    Hi Dy365Fan 

    The field/column - Connections (Role to Contact or Role From Contact) can be added to the view you want displayed on the subgrid.

    pastedimage1654011304807v1.png

    Let me know if this helps.

  • Dy365Fan Profile Picture
    Dy365Fan on at
    RE: Two relations for sub grid

    maybe I didn't express myself well. Again: I would like to show two relationships in one subgrid. See the screenshot.

    I would like Connections (Role From Contact) AND Connections (Role To Contact), related to contact where the subgrid is in.

    pastedimage1653990375288v2.png

  • Suggested answer
    Amit Katariya007 Profile Picture
    Amit Katariya007 10,409 Super User 2025 Season 1 on at
    RE: Two relations for sub grid

    Go to the sub-grid. Get the view name which is used.

    Now update the filter criteria as per your requirement u will have to add OR condition in the view, Publish and check it after that.

  • Suggested answer
    Scosec Profile Picture
    Scosec 95 on at
    RE: Two relations for sub grid

    Hi,

    I think you can do this easily with the filter criteria inside the view u are using in the subgrid.

    Try using the grouped OR condition

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 51 Most Valuable Professional

#2
Ramesh Kumar Profile Picture

Ramesh Kumar 42

#3
David Shaw_UK Profile Picture

David Shaw_UK 27

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans