Creat records automatically through relationship after status change in related table
I have a table E, in which I have records with status "Pending" and "Shipped". And there's a shipping table, with record status "Shipped" and "Closed". In table E, records look like this:
Status Model Qty
Pending a 10
Shipped b 20
I want to create a new record automatically in shipping table after Status in table E changed to "Shipped". And the new record will have a "Shipped" status in table Shipping.
How can I achieve this? And what could be my options on relationship building?