Record update from one table to another table

Finance and Operations/AX Developer Forum
1

Hi All,

I have created two tables naming T_1 and T_2.And have create two forms with these two tables as Table_1 and Table_2 respectively.

The field list in both the tables are same.And the fields are

1.LeaveId

2.NoofDays

3.RequestRaised

6574.updating.JPG
6574.updating.JPG713×689 60.4 KB

“RequestRaised” is a checkbox field.For a particular record When the “RequestRaised” field in Table_1 is updated,The same record in the Table_2 should get updated.

How to update the “RequestRaised” in Table_2 when the “RequestRaised” in Table_1 is updated.

Appreciate your help.

Thank You

Rajee

2

Hi,

You can write the code in the modifiedField method of the Table 1.

Hope this helps, If you any further input let me know.

3

Hi

the following code in table update methods in table1

public void update()

{

Table2 Table2;

;

if (this.RequestRaised == noyes::Yes)

{

ttsbegin;

select forupdate Table2 where this.RequestRaised == noyes::Yes;

Table2.RequestRaised = noyes::Yes;

Table2.doUpdate();

ttscommit;

}

super();

}

Don’t forget verfied Solution if resolve your issue

4

Thanks Syed and Kumaran!