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 / Dynamics 365 general forum / how does many to many ...
Dynamics 365 general forum

how does many to many relationship work in d365

(0) ShareShare
ReportReport
Posted on by zaub 267

I have two entities TEACHER and STUDENT

one student may have many teachers

i have created 1:n relationship on student (one student may have many teachers)

i have added teacher subgrid on student to show teachers on student form ( IT IS WORKING)

working.png

student-to-teachers.png

------------------------------------------

one teacher may have many students

i have created 1:n relationship on teacher (one teacher may have many student)

i have added student subgrid on teacher to show students on teacher form ( IT IS NOT WORKING)

notworking.png

teacher-to-students.png

Does any one know WHY student subgrid not showing students on teacher form ? ?

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: how does many to many relationship work in d365

    Hi,

    As I know,CRM provide us many type of relationship-

    1:N - 1:N relationship refers to the relationship between two entities, in which a single entity record can be associated with multiple related entity records.

    For example- One account can be associated with many contacts.

    N:1 - N:1 relationship refers to the relationship between two entities in which multiple entity records can be associated with single entity record.

    For example- many records of contact entity can be associated with single account Entity.

    N:N – N:N relationship refer to the relationship between two entities, it states that, many records of one entity can be related to many records of another entity.

    For this issue, I think you may need to create N:N relationship between these two entities.

    Here is an article which introduces it.

    How To Create Manual Many To Many Relationships In CRM

    community.dynamics.com/.../how-to-create-manual-many-to-many-relationships-in-crm

    Hope it helps.

    BR,

    Judy

    -----------------------------------

    Appreciate to Mark as Answer if it is useful.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Dynamics 365 general forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans