Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

Opening a form using the + of subgrid

(0) ShareShare
ReportReport
Posted on by 428

Hi All, 

I am currently showing a form when a user will click the + button on a sub grid rather than the lookup icon and this is when entities have 1:N relationship. 

Problem is now i have to achieve similar set up of opening a form using +button of a sub grid but this time entities have N:N relationship, how can achieve this is this possible at all ? 

Thanks,

PS

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: Opening a form using the + of subgrid

    Hi PS10,

    We have to create a manual N: N relationship.

    First please read this blog on creating N: N relationships manually.

    https://carldesouza.com/understanding-intersect-entities-and-nn-relationships-in-dynamics-365/

    After we create the N: N relationship, D365 will automatically create an intersecting entity. After connecting the N: N relationship for two records, a record is created for this intersecting entity.

    pastedimage1583744524420v1.png

    Assuming an N: N relationship is created between entity A and entity B, D365 will automatically create an internal entity C.

    If we want to create a B record by clicking the + button in the N: N sub-grid of A, then only C record will be created, not B record. Therefore, the form opened after clicking the + button is the C form, not the B form.

    There are A and B lookup fields in the C form. We can click the + button in the B lookup field to create a B record, and then use it to fill the B lookup field in the C form. In this way, we successfully created a B record that has an N: N relationship with the A record.

  • Suggested answer
    M.Azwar Alam Profile Picture
    M.Azwar Alam on at
    RE: Opening a form using the + of subgrid

    Hi,

    You can create intersect entity that is manual many to many relationship. Then you would be able to open form using intersect entity

    Mark answer as verified, if it is feasible for you

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans