How to filter values of one table IF in other table is verified a particular condition

HELLO TO EVERYONE!

I have two table called “CORSI (Courses)” and “DIPENDENTI (employees)” like in photo and I’ve set this reference: REF_ROWS(“CORSI”, “DIPENDENTE”).

I’d like to view in the app the data of table “CORSI” but only for Employees who have in the column “STATO” in table “DIPENDENTI” the value “Attivo”. So, the main question is: how can I view the values of table “CORSI” only IF the column STATO in table “DIPENDENTI” is “Attivo”?

TKS in advance!!

Solved Solved
0 9 579
1 ACCEPTED SOLUTION

Yes, exactly. Now use that in your slice.

Only if you needed to keep the value directly in the table for some reason, which you don’t need that here.

View solution in original post

9 REPLIES 9
Top Labels in this Space