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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

To add fields on the form from different tables

(0) ShareShare
ReportReport
Posted on by 1,638

What possibly be the best way to add fields from another tables on a form? 1. Flowfield? 2. Or declaring a variable and assigning the value by writing code on onaftergetrecord () trigger via GET function? Does flowfield affects the database performance?

*Need to just display the information*

  • Lars Lohndorf-Larsen Profile Picture
    Microsoft Employee on at

    Hi Tanya,

    You can do both. It depends on the exact scenario. The two methods you mention are both very sensible. Flowfield is maybe easier while GET takes more code, but gives you more freedom. If it is a List form/page, then be careful adding Flowfields to it, as it may indeed affect performance. On the other hand, so would GET. And with Flowfields, depending on the version, some work has been done to optimize calculating flowfields on pages.

    So in short I think there is no black and white here in my opinion but if it is on a list page then just make sure that the flowfield / GET is as optimized as possible.

  • Suggested answer
    JAngle Profile Picture
    159 on at

    As Lars has said no defined answer. Extra remarks to help or hinder.

    If the users need to sort or filter with the field then it existing on the table is important. If they don't then you have another option. On the page you can create a calculated field using a supporting codeunit. It is for sure more code but you can define lookup or drill down aspects. Same as a flowfield but the data only exists at page runtime.

    If you have the base app to look at, check out a fact box page. It uses that concept and the application is littered with fact boxes.

  • tanya07 Profile Picture
    1,638 on at

    Thankyou for your kind suggestions , it helped.

  • SnowWizard Profile Picture
    5 on at

    If the users need to sort or filter MyGroundBiz with the field then it existing on the table is important. If they don't then you have another option. On the page you can create a calculated field using a supporting codeunit. It is for sure more code but you can define lookup or drill down aspects. Same as a flowfield but the data only exists at page runtime.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 774 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 569 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 296 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans