Automatically update field of several rows based on input from another row in the same table workflow

[kevin_merakjing]

Hi,

I have a table with description as below :
Table name : Transaction Table
Fields : Trx Date ; Transaction ; Verification Date

There are several Transactions with the same Trx Date.
I would like to have such action automatically : when the Verification Date of a Transaction is input manually, the Verification Date of the other rows of Transaction with the same Trx Date are also being filled.
(Also mean when I verify a certain row of Transaction by inputting the Verification Date manually, the other rows of Transaction with the same Trx Date have also been verified, and the Verification Date are inputted automatically by Action / Workflow)

I’m stuck in the Reference Rows in the Action : execute an action on a set of rows.
How should I list out all the Transaction with the same Trx Date as the row that just verifed (manually inputted Verification Date)

Or is there any other simple way? (If possible with steps).
Thx