Security filters in a table

[HectorIRC]

Dear:

I am a bit complicated, as I need to limit the access of some tables according to the mail that is in a different table.

I have a table called “ASSOCIATES” where there are users that belong to different “DEPARTMENTS”. In my case, I need to limit the access to some tables to Francisca, since she belongs to the “ATTENTION” department (See the following picture).

I need her to not be able to see the data in the table “PROVEEDORES”.

I don’t know how to do it from the security filters menu.

[Steve · Accepted solution]

Try:

IN(
  USEREMAIL(),
  SELECT(
    ASOCIADOS[CORREO],
    ("ATENCION" = [DEPARTAMENTO])
  )
)

[HectorIRC]

It worked perfectly for me. Now I will understand the logic behind it so I can apply it in other cases. Thank you very much indeed