web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / How to show top first ...
Microsoft Dynamics CRM (Archived)

How to show top first latest record from child custom entity in parent form?

(0) ShareShare
ReportReport
Posted on by Ashish Moradiya 515

Hello, 

I am extending information for Opportunity entity by creating custom ExtendedInfo Entity with 1:N relationship.

I want to see only top 1 (latest) record from ExtendedInfo entity in opportunity form. I already tried creating view showing record descending order by CreatedDate field and use subgrid with with limiting number of rows which creates two problem for me.

1. Not allow to set 1 value

LimitRow.jpg

2. It shows pagination (multiple records)

How can I achieve my requirement?

Thanks in advance...

Regards,

Ashish

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    ashlega Profile Picture
    ashlega 34,477 on at
    RE: How to show top first latest record from child custom entity in parent form?

    Hi Ashish,

      if there is always only 1 extended entity per opportunity (is it, literally, 1:1?), it might be easier/more straighforward to use a combination of a lookup/quick view form (add a lookup to the opportunity entity, create a quick view form for the extendedinfo entity, and add both the lookup and the quick view form to the opportunity form instead of that subgrid)

      With the subgrid, you can probably use javascript to display top 1, but it will still be a subgrid ("+" button, "delete" button, etc)

  • Suggested answer
    ashok teja Profile Picture
    ashok teja 290 on at
    RE: How to show top first latest record from child custom entity in parent form?

    Hello, 

    Using script you can filter the records in subgrid as per your requirement. 

    Have a look at the following link 

    https://mydynamicsmscrm.wordpress.com/2016/11/18/filter-subgrid-using-script/

    If found useful, please mark the answer as verified.

    Thanks

    Ashok J

    XRMWEBKIT | CRMPORT | DynamicsHelpmate 

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
Christoph Pock Profile Picture

Christoph Pock 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans