Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Dynamics 365 general forum / how does many to many ...
Dynamics 365 general forum
Answered

how does many to many relationship work in d365

(0) ShareShare
ReportReport
Posted on by zaub 265

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 Microsoft Employee 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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans