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

[Steve]

Gustavo_Panzer:

I can not get it to only list the field NAME AND SURNAME / COMPANY NAME, those that meet the condition described.

What have you tried?

[Gustavo_Panzer]

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”)

[Gustavo_Panzer]

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

[Marc_Dillon · Accepted solution]

Remove the bold part below:

Gustavo_Panzer:

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

[Gustavo_Panzer]

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

[Steve]

Gustavo_Panzer:

but the app gives a fatal error

Please provide a screenshot of the error.