Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Business Central forum

Accessing values from one table to another

(0) ShareShare
ReportReport
Posted on by 700

Hi All,

I have created two tables - 'Entitlement Setup' and 'Entitlements'. In 'Entitlement Setup', there are two fields for Month and Year whereas, in 'Entitlements', I have created a field in which Month and Year values from 'Entitlement Setup' table are needed to be displayed after combining them.

How to achieve this, please provide AL code.

Thanks!

Categories:
  • Suggested answer
    Avinash B Profile Picture
    1,455 on at
    RE: Accessing values from one table to another

    Hi,

    You can write a piece of code on the OnInsert trigger of Entitlements table to combine these fields.

    Like:

    EntitlementSetup.Get();

    CombinedField := FORMAT(EntitlementSetup.Month) + FORMAT(EntitlementSetup.Year);

    Regards,

    Avinash B

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans