Comparing fields in two tables

Business Central/NAV Developers Forum
1

Hi everyone,

I have two tables with 6 identical boolean fields (same Id, same name).

I need to synchronize those six fields in both tables: for example when the value of bool1 changes in table1, I want it to change automatically in table2.

Is it possible???

2

it depends upon the link between 2 tables.

if there is a link then you can get the other table in onvalidate and change.

3

Hi poppins,

Lets say ‘A’ (with fields 1,2,3,4,5,6) as your first table and ‘B’ (with fields 1,2,3,4,5,6) as your second table. If you want to update the datas from the table ‘A’ to table ‘B’.

Inside the C/AL of table A, create a variable of B table in the C/AL globals , say temp. Now under the OnValidate trigger of the boolean fields, give the assigning codes using dot operator. Ie.,

temp.INIT;

temp.1=A.1;

temp.INSERT;