I need help relational tables (sorry for my English)

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

What have you tried?

SELECT(Preordenes[Nombre y apellido / Razón Social], (Preordenes[Aprobada] < > True), TRUE)

Cannot compare List with Yes/No in (PREORDENES[Aprobada] <> “TRUE”)

Column Name ‘Nombre y Apellido / Razon Social’ in Schema ‘Pagos_Schema’ of Column Type ‘Ref’ has an invalid data validation constraint ‘=Select(Preordenes[Nombre y Apellido / Razon Social], (Preordenes[Aprobada] <> TRUE),TRUE)’. Cannot compare List with Yes/No in (PREORDENES[Aprobada] <> “TRUE”)

https://www.appsheet.com/newshortcut/f58c6aa7-7c32-46ab-9e93-10fadeacdc1b

Remove the bold part below:

1 Like

Marc, I removed the indicated, the expression is now valid but the app gives a fatal error

Please provide a screenshot of the error.