Attached is a reference image, and actually think and apply it to multiple tables in different ways.
Perhaps the solution could be using triggers, but I wonder if there is any way to do this using grocery crud, or otherwise appreciate the support of any member with the code of the trigger in mysql
According to the attached image, I have two tables (project and client)
First record of customers, so when I record the projects listed clients using set_relation.
Example, I have proposed the following records:
Table Project:
'proj001' 'project one', '02/01/2014', '29/10/2014', 'active', '1'
Table Client:
'1', 'one client', 'lima peru', '994584124', '1164661545'
'2', 'client two', 'Caracas Venezuela', '154584124', '6498478965245'
'3', 'client tree', 'santiago chile', '9545584124', '1654956245'
So my first project log I linked to the first client (id_client = 1) when I delete the client "one client" my client crud value project.id_client already registered will remain "1"
Eh researched and apparently can use the callback, but in your examples are always based on the same table, but not in two separate tables, not if someone can help me with a fully explicit example.
