Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Grid vs. Relationships

Posted on by 690

Hello everyone,

I have an entity called Supplier that has a relationship with the Control entity. There is a relationship between Supplier and Control, where a Supplier has N Controls, so far so good ....
But inside the Control I also have a relationship with Account, where an Account has N Controls.

When I create the Control I do it from a Vendor and fill in the Account.

In other words, each Supplier has N Controls, and each Control has a linked Account.
But how do I make the Controls appear in the Accounts?

Each account can only view your Controls .. How to do this?

*This post is locked for comments

  • RE: Grid vs. Relationships

    I still do not believe the relationship between Account and Control, I do not understand your point N: Intermediate N instead of N: N Native?

    Each Control will have a lookup within the client, where there are several Controls for different Customers, but within the Client the grid can only bring those Controls of a certain Client.

    This is possible natively

  • Suggested answer
    PS Profile Picture
    PS 23,577 on at
    RE: Grid vs. Relationships

    Go to settings>>customization>>customize the system>>entity>>accounts>>forms(main)>>Add subgrid (Top ribbon button)>>Only related records of Control>>Save>>Publish

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Grid vs. Relationships

    Hi Ricardo,

    It sounds like the Controls entity is being used as an intermediate N:N and NOT the native N:N relationship.

    Since the relationship is there, all you will need to do is add the Controls subgrid to the Accounts form.

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans