I need help relational tables (sorry for my English)

[Gustavo_Panzer]

I am trying to develop a Treasury Management app, in which different users load a Payment Preorder in the PREORDERS table with three possible recipients, namely Suppliers, Employees or Beneficiaries, which must then be approved, must be selected by a single user ( The Treasurer) and generate the payment in the PAYMENTS table selecting from the Preorders table, the possible recipients in those records that have the STATUS = Completed field and the APPROVED <> TRUE field. I can not get it to only list the field NAME AND SURNAME / COMPANY NAME, those that meet the condition described.
Thanks in advance

Hoja de la Google sheet PAGOS

Hoja de la Google sheet PREORDENES

Columnas desde la app