If there are 2 tables in the cycle and the second table takes data from the first table by codes, will it be recalculated if the first table changes?
Tables within a loop have an important feature that is enabled by default — it automatically recalculates related tables within a single loop.
How it works: if you have two tables within a loop and the second one, for example, uses select to fetch data from the first one, then when changes are made to the first table, the second one will be recalculated automatically.
How do I take data from one cycles table and take data from another?
All select** functions work without additional parameters.
In this pattern, can the first table take data from the second table?
Yes. Moreover, they can take data from each other. When changes are made in the first one, the second one will be recalculated, and then the first one again.
In what order are the tables recalculated within the cycle?
In the order of sort tables.
Why is it necessary?
So as not to write additional action codes.