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