Create automation to add or edit a row in a table triggered by the add or edit in another table

[Madel]

Hi.

I have 2 tables. Table A registers appointments, including the payment. Table B is an accounting book to register every transaction.

I want to create an automation to add or edit a row in table B, triggered by the add or edit of a row in table A. Therefore I created a process using the "add new rows" option . It works well when I add a row in Table A, but when I edit a row in table A, a new row is created on Table B instead of editing the existing one.

Any help is appreciated.

Regards

[SkrOYC]

---

@Madel wrote:

a new row is created on Table B instead of editing the existing one.

---

Are the tables related in any way?