i have 3 tables.

Table 1: Expenses(fields: Date, Details, Invoice PDF, Amount, Category)

Table 2: Income(fields: Date, Details, Amount)

Table 3: Total(fields: Date, Details, Expense, Income, Total)

What i need is:

when i’m making a new entry on Table 1, fields Date, Details, Expense from Table 3 to auto-filled on a new entry. If i change something on that entry on table 1 (on that row) to be changed as well on Table 3.

when i’m making a new entry on Table 2, fields Date, Details, Income from Table 3 to auto-filled on a new entry. If i change something on that entry on table 2 (on that row) to be changed as well on Table 3.

and in the midtime in every row on field Total the expenses/income to adding/subtract accordingly.

Its possible to be done with automations?