Help! how to get a listing of a table filtered by the column of another table that is not referenced to the main table

how to get a listing of a table filtered by the column of another table that is not referenced to the main table.

I can do this seamlessly from SQL Server by simply creating a view, but if I add the view to appsheet, appsheet creates it as a separate table.

The question would be how can I filter the slice with the expressions in appsheet.

Here is an image with the structure of the tables.

I really know the way to create the Slices, where I am really having problems is in the creation of the formula to be able to filter and reach the objective that I mentioned above.

I don’t know if I could express myself well about the objective that I want to achieve.

Thanks a lot!

1 Like

Could you explain in plain language what you want the filter to do? I’m happy to try to help with the expression.