Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Answered

Show only related records in d365 sales

Posted on by 55

Hi,

I have two custom entity 'Fund' and 'Allocation', with list of imported data. 


I have created a 1->N relationship between them, Fund(1)-> Allocation (Many). I am showing all the list of fund records in fund entity form, when I open one fund records I have a tab which shows all the Allocation related to the fund, based on the fund ID.

As there is already a relationship under funds I created a subgrid with only related records to Allocation, but the subgrid shows nothing

  • Indhu Profile Picture
    Indhu 55 on at
    RE: Show only related records in d365 sales

    Thanks Kenneth

  • Suggested answer
    RE: Show only related records in d365 sales

    Hi, try this:

    1. Create quick view form on Account entity.

    2. Add sub-grid of related records from desired entity (every new entity has relationship with account).

    3. Add created quick view form on specified form which we want to display related to the records.

    4. It should work now.

    If this answers your question, please check it as verified to help ithers finding useful information.

    Welcome to this amazing community.

  • Pradeep Rai Profile Picture
    Pradeep Rai 5,490 Super User 2024 Season 2 on at
    RE: Show only related records in d365 sales

    Hi Indhu,

    Please mark this as VERIFIED if helps.

    Thanks,

    pradeep

  • Suggested answer
    Pradeep Rai Profile Picture
    Pradeep Rai 5,490 Super User 2024 Season 2 on at
    RE: Show only related records in d365 sales

    Hi,

    Whenever we create any 1:N relationship in dynamic CRM then it automaticaly create the Lookup field on Respective entity.

    For e.g.

    In your case We have Fund and Allocation entity. So, when we created the 1:N relationship then LOOKUP field get generated on Allocation entity.

    Below the screenshot for your reference

    pastedimage1630995641121v1.png

    So, please check allocation entity using CRM customization -> Allocation-> Fields

  • Indhu Profile Picture
    Indhu 55 on at
    RE: Show only related records in d365 sales

    what is this?

     1. As you have imported the data then please check Allocations records, because the fund lookup should be populated on each allocation records. if not then it will not visible on subgrid

    Should I create a field named fund(lookup field) under allocations?

  • Verified answer
    Pradeep Rai Profile Picture
    Pradeep Rai 5,490 Super User 2024 Season 2 on at
    RE: Show only related records in d365 sales

    Hi @Indhu

    I have setup same scenario on my CRM Instance.

    and it is working properly as shown below:

    pastedimage1630914448740v1.png

    I would suggest below checkpoints for your case:

    1. As you have imported the data then please check Allocations records, because the fund lookup should be populated on each allocation records. if not then it will not visible on subgrid

    2. Subgrid property should be same as below:

    pastedimage1630914532091v2.png

    Thanks,
    Pradeep.


    Please mark this as VERIFIED if it helps.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans