Accessing values from one table to another

(0) Share

Report

Posted on by Dynamics 365 Busine...

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:

Other

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Avinash B 1,455 on at

Like (0)

Report

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

Was this reply helpful? Yes No