How to increase the value of part of the ID (nomenclature) in an Insert Into
Summary:
In our business logic each Servprov can have 2 or more Accessorial Code.
Our objective is that, by checking the 'Active' box of a Rate Record, an Accessorial Cost with a specific nomenclature is automatically created for each Accessorial Code that has that Servprov.
At the moment, there is an 'Agent 1' that, when the Active box of a Rate Record is modified, triggers the call from another 'Agent 2'.
This 'Agent 2' consists of some variables and a 'FOR EACH' action that refers to the fact that, for each Accessorial Code that exists for that Servprov, it triggers another 'Agent 3' in charge of performing the INSERT INTO ACCESSORIAL_COST and creating an Accessorial Cost Gid for each Accessorial Code.
0