I want to have columns in a tablebox for each bank account (with the caption of the bank account code, and the field values (balances) would be calculated from a code). As bank accounts can be modified dynamically, how is this possible?
Sound like you want a Matrix box - have a look at the items by location form for an example.
OK, thank you, this is what I need. But I still a question:
How is the relation given in the matrix between the items and locations? In Item table I can not find location field.
You will not find Location code in the Item Card, but you will find Location Filter (FlowFilter) [:)] And the quantity shown is actually Inventory field in Item card, which is a FlowField to Item Ledger Entry with Location Filter as one of the filter.