1 2 Previous Next 27 Replies Latest reply on Jul 13, 2012 11:07 AM by philmodjunk

    Creat records automatically through relationship after status change in related table

    JillX

      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!!

        1 2 Previous Next