The combination of 2 Select expresion

[Madalin]

Hello.
Please help me with a solution.

I have 2 tables
https://app.screencast.com/UIggaZDt1g4c6
https://app.screencast.com/OPmeh8WUVFfAM
https://app.screencast.com/9i1wZlhDXwkzh

In the "Operare Lunara" table, when I add a Firma, I want it to stop appearing the next time I add a row

In the "Operare Lunara" table when the "Activ-Inactiv" has N, I want it not to appear in ref dropdown

Both situations are going well

Parteneri[CUI] -
SELECT(Operare Lunara[Firma], [operare_id]<>[_THISROW].[operare_id])

Parteneri[CUI] -
SELECT(Parteneri[Denumire Firma], [Activ-Inactiv]="Y")

When I combine them, i.e. both conditions must be met cumulatively, it does not work.
Parteneri[CUI] -
SELECT(Operare Lunara[Firma], and([operare_id] <> [_THISROW].[operare_id],
[Firma].[Activ-Inactiv]="N"))

Can you help me with an advice?

[1minManager]

My best guess is that its because Parteneri[CUI] and Operare Lunara[Firma] are not lists of the same type.  Or that they are both Ref's, but pointing to diferent data.

[Madalin]

I know. I am looking for a solution.