web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

How to display reference group filed in custom form

(0) ShareShare
ReportReport
Posted on by

Scenario: I have 3 custom tables A, B and C. 

Table B is using RecId relation form table A for reference group to show the record of table A. 

Relation: TableB.RecRef==TableA.RecID;

Table C has lookup field from table B. 

Relation: TableC.VehicleId==TableB.VehicleID;

There are forms A, B and C respectively for Table A, B and C. 

I want to display the record the record from Table B to table C using display method. 
Since there is RefRecId in Table B which is used for reference group from Table  A. 
So ultimately i have to display the record from table A and Table B using only relation from Table B in Table C. 
Using Table Display method 
Display RefRec refRec()

{

 return Table B :: find (this.VehicleId).RecRef;

}

it only show recId of records from table A, but i need to display each field on same RecId.

Please help me out.. !!!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mea_ Profile Picture
    60,284 on at

    Hi ShubhAX,

    Instead of using RefRecId create new EDT,  set ReferenceTable property to Table A on this EDT, add relations under "Table References". Then use it in display method and as a type for Table B field.  You can use EcoResProductRecId as an example. 

  • Community Member Profile Picture
    on at

    Could you please elaborate is more as i want to display method on table c. I have created the edt and write the method but and error is showing.. Table B is not containing this field.

  • Mea_ Profile Picture
    60,284 on at

    Do you want to share new code ? It should be same display method but instead of refrecid it should return your new EDT.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans