Automation in Child Table wont Trigger the Parent Table

[stephenrich]

Dear Appsheeters,

I have two table:
1. The Parent table [Purchase Order] with [PO_No] as Key.
2. The child table [Purchase Order Details] with [PO_No] and [PO_RowNo] as Keys.

I have two actions:
First Action is in [Purchase Order Details]:
Action Name: U.1. Update PO
For a record of this table : Purchase Order Details
Do This: Data: Execute an action on a set of rows
Referenced Table: Purchase Order
Referenced Rows: LIST([PO_No])
Referenced Action : U.1.1. Update PO (this is the second action in the Parent Table [Purchase Order])

Second Action is in the Parent Table [Purchase Order]
Action Name: U.1.1 Update PO
For a record of this table: Purchase Order
Do This: Data: Set the values of some columns in this row
Set These columns:
PO_Detail_Modified_By = USEREMAIL()
PO_Detail_Modified_Date = NOW()

after that, i create an automation in the Child Table [Purchase Order Details], with Event "When PO Detail is Updated"

Everytime i change or add the [Purchase Order Details] record, somehow appsheet only execute the Action in [Purchase Order Details] which is U.1. Update PO, but it wont trigger the second action in the parent table [Purchase Order].
I have done so many similar actions like this for my other modules, name [Sales Quotation] & [Sales Quotation Details], [Sales Invoice] & [Sales Invoice Details] and those actions always successfully trigger both actions, but now, in the purchase module, it just wont trigger the parent action. Please Help.

[WillowMobileSys]

---

@stephenrich wrote:

Everytime i change or add the [Purchase Order Details] record, somehow appsheet only execute the Action in [Purchase Order Details] which is U.1. Update PO, but it wont trigger the second action in the parent table [Purchase Order].

---

Make sure the "U.1.1 Update PO" does NOT have any expression in "Only if this condition is true" property that might prevent it from executing.

If not, how are you determining it's not executing? 
Are you looking at the Monitor Logs? 
Could it be that the action IS executing but there is no change - i.e. same values are being updated?

I hope this helps!

[stephenrich · Accepted solution]

I think the culprit is this Options. 
It turns out that we need to turn these two options on.