We start with the count at 0.
I got 0 by relating the EMAIL_RESTAURANT column of the menu table
with EMAIL_RESTAURANT from the confirmed orders table.
The first time it gives 0 to all the articles.
When you confirm another order, you should give 1.
That is, the count is made with that column. And the subsequent relationship from the table confirmed orders with the articles is going to be done with the column EMAIL_RESTAURANT_COUNT.
You have to use matrix formula, I only did that example in an excel.
I’m not very good at explaining, but the most important thing is the logic.
I do what I can within the short time I have.