Delete column in linked table

Good morning to all guys. I am faced with a new obstacle in the development of my app.
I have 3 linked tables, “Menu of the day”, “Menu dish mapping”, Dishes. The “Menu of the day” table is a container of several “Menu dish Mapping”. Each “Menu dish mapping” only ever has one associated dish. Now I would like that, if one of my dishes is deleted and that same dish is inserted within a “menu dish mapping” which in turn is contained in one or more “menus of the day”, I would like all the “menu of the day” that contain it are deleted. However, I am encountering an error that I cannot overcome.

This topic was automatically closed after 70 days. New replies are no longer allowed.