One of the steps is to create the action and the other is to add it in the behavior part in Event Actions and there you select your action in your Budget Balances view.
Note: Remember that the action must be the same table in the Budget Balances view
is [Reg_Item_ID] the key column of the table ‘Register’ ?
If not , you need to replace it with the key column of the table Register (let’s call this key register_key). To make this link, each item of the Budget Balance table need to have a referenced [register_key].
If they don’t have one yet, you need to create it through a virtual column
examples, let’s say i’m currently in tableA :
1 - this linktorow is an action that’ll link to a row, from list of tableA to detail of tableA :
2 - this linktorow is conditional : if It find any row in TableB [Dossier] that matches the value of [THISROW].[Dossier] (tableA) , it links to it (any(select…) / if it does not find any, it links to TableA detail
i use this when I create a reference of tableA in a tableB, after the creation of tableA row