Heavy Action...! Multiple table

[Samy_Kermia]

Hello everyone ! 🙂

So here it is, I created an application that aims to process products with a time delay.

So I have two tables that work together.
Example:
Condition 1: Product processed, it disappears from table 1 but remains in memory on table two. Three days later, if no news, it is imported to the next category and disappears from table 2.

Condition 2: It has already been sold and therefore cannot be processed.

SO

A "Sold" action must be able to remove the product from table 1 & 2.
I imagine that it would take a system so that the simple action of deleting the row from table 1 leads to the search for the identical product in table two and continues with its deletion.
Luckily, each product has a unique code.
I spent the afternoon trying things but... I didn't succeed.

I therefore defer to you.

[Joseph_Seddik]

I'm not sure where you are having difficulties. Assuming you want a composite delete action you can:

1. Create an action to delete a row in another table (Data: Execute an action on a set of rows).
2. Create another action (Grouped: Execute a series of actions), in which you select the current table's Delete action and the action you've just created above.