How to "scan" a table?

You would use the for loop command.

for loop1 in select Table1 do
    loop1.(field1 := 100);
    let x := first((select Table2)[field2 := loop1.field2]);
    loop1.(
            field3 := x.field3
            field4 := x.field4
           )
end

So the first line sets a variable for each record in the loop. Then the "in" tells Ninox where to loops. This can be a select or an array.

Line 2 is an example of a simple action. Where you would set field1 in all records in Table1 equal to 100.

Line 3 - 7 shows a more complicated action. First we find the first record in Table2 where the field2 matches field2 in the record of the current loop. Then we set field3 and field4 of the record in the current loop to the value in the loop to the value in x.