Autopopulate Bank and IBAN fields in a subform

Autopopulate Bank and IBAN fields in a subform

In the deals module I've created a subform for us to recap all how the payments will be executed.

These will appear as a table like that:

Percentage      Phase      Mode                        Bank      IBAN
30                     at order   Bank transfer            BANK1   IT20X23849327452348765
70                     at test      SEPA Direct Debt     BANK2   IT20X23849327452348765

We'd like to have the BANK1, BANK2, IBAN1 and IBAN2 automatically populated as follows:
BANK1 and IBAN1 should correspond to our bank and IBAN (therefore 2 field text).
BANK2 and IBAN2 should be taken from the Bank and IBAN fields inside the account to which the deal is connected to.

A final check to see if 100% of the payment have been allocated would also be welcomed.

We will be thankful for any help received.

Kindly regards

Marco Carolli