I have 2 tables - “product” and “supplier”
These tables are related: in the table “product” I see the supplier, in the table “supplier” I see what goods he has.
When I am in the “supplier” table and click delete product, only the relationship between the tables is deleted. There are no changes to the “product” table.
How to make it possible to remove goods from the table “supplier”? To remove not only the relationship between the tables, but also goods from the “product” table.