Re: deleting rows from 2 corrseponding tables

Home Forum General deleting rows from 2 corrseponding tables Re: deleting rows from 2 corrseponding tables

#5883

Drag on a hidden helper field. Create a behavior behind when a button is pressed. Place the value of Table 1 System Name – current row in the hidden helper using a set field. Then create a behavior to loop through Table 2 and look for that value in the System name row and delete the row when found.

Here is how: Set Table Rows behavior object – Move to first row. Then use a Simple Branch (does value Table 2 System Name – current row = Hidden Helper?) If true, use a Set Table Row object – Delete current row. If false use a Set Table Rows object Table 2 move to next row. Then Simple Branch object (was last command successful?) If true, loop back to first Simple Branch. If false go to Exit behavior because you have reached the bottom of Table 2.

Workflow software, Process software, Procedure software