Info from one table into another table as basis for a RLS

[Orstenpowers]

Hi Ladies & Gentlemen,

As you can see from the screenshot below, I am using two fields for my query; “Sold to customer” and “BP_PL_to_exclude”.

Through the “Customer No” I created a relation between these two fields. So far, so good.

However, in the end this model is supposed to get a RLS, in which I would like to define the following:

Area = “Europe” &&

Customer status <> “PL customer”

To do so, I would need to get another column into “Sold to customer”, but how to get the information about Customer status from “BP_PL_to_exclude” into “Sold to customer”?

Is there someone out there who can help me, please?

Best regards

[LQuedas]

Hey @Orstenpowers ,

would you like to screenshot the two tables with the relationship between them?  i.e. what is the filter direction between them?

Cheers, LQ