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

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Join columns with the same relationship into one

(0) ShareShare
ReportReport
Posted on by 10
Hello community, I present my case to you. On the Line Level Purchase Orders page, add 3 new additional withholding fields, all 3 fields are related to the same table.
 
 
Generate a shortcut on the statistics page, to show the audit of these 3 fields.
 
But my scenario is that I am looking to join these 3 fields and represent them in one, in this case in /RET2 Identifier/:
 
 
any ideas?
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    95,305 Super User 2025 Season 2 on at
    Join columns with the same relationship into one
    Hi, do you want it to display like this?
    In the OnDrillDown Trigger of the shortcut on the statistics page, open the first line of records (Same as your example), and then insert the other two lines of records in your code.
     
     
    Hope this can give you some hints.
    Thanks.
    ZHU

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,377

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,696 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,512 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans