AnsweredAssumed Answered

Creat records automatically through relationship after status change in related table

Question asked by JillX on Jun 21, 2012
Latest reply on Jul 13, 2012 by philmodjunk

Title

Creat records automatically through relationship after status change in related table

Post

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?

Thank you!!

Outcomes