ANY(SELECT

[makeappsheet]

Good morning friends,

I have this table, "PEDIDOS", with these fields:

Y esta tabla relacionada

The ARTICLE_ID field of the ORDERS Table is a ref to the ARTICLES Table and in the INITIAL VALUE section it has this expression:

ANY(SELECT (ARTICULOS[ID_ARTICULO],[ID_PROVEEDOR]=[ID_PROVEEDOR].[ID_PROVEEDOR],FALSE))

And this related table, ARTICLES:

I need that when a SUPPLIER_ID is chosen, only the ARTICLES related to that SUPPLIER are filtered and displayed.

Now it does not work correctly for me, since the list appears complete, without selecting ITEMS by SUPPLIERS

Thank you for your time, best regards