Security Filters and Slice Filters conditions miss match

[AGairAdmin]

my app has some tables that need security filters that are not related to the useremail() ,

i have a table called "users table" , it contains the "Email" and "company key" 

I'm trying to get the security filter to look at the "useremail()" then  'Users table', "email" = "Company Key"  

so that way when a user opens the "equipment" table and their user has a "company key" attached they should be able to view all equipment for that company by "company key" 

[Marc_Dillon]

I assume your equipment table has a [company] column, referencing a company record.

I also assume you are already filtering out the company table with security filters as well.

If so, you can simply put this for the security filter on equipment:

ISNOTBLANK( [company].[company key column] )

[AGairAdmin]

i don't have any other filters or slice row filters yet, this is the first one. 

3 Tables 
-Users
-Company Employees
-Equipment

common columns
-Email
-Company Key

for the table "Equipment list" I would like to set the security filter to show only matching "company Key" by looking at "useremail()" then look at the table "company employees" column [Email]

[Marc_Dillon]

>>"matching "company Key" by looking at "useremail()" then look at the table "company employees" column [Email]"

Bad idea.

Forget about that and work towards what I explained above. Filter down the company table first, then all other tables can have super easy cascading security filters.