Different RLS on different tables that have a relationship

[NinnaN]

Hey 

I have two pages with data from the HRP SKF table and two pages with data from the HRP SKF, HRPM SKF and HRPA SKF tables. I need corresponding RLS that only filters the hierarchy in the HRP SKF table on the two pages with only information from HRP SKF and I need RLS that filters the information from the HRPM SKF tabel on the pages with data from the three tables. 

I have the following data model:

I have a RLS table that does not have a relationship with the other tables. I have the following information to manage roles:

I have hierarchies in the HRP SKF table and the HRPM SKF table:

I have made the following security roles:

Right now I get the correct information on the two pages containing only information from the HRP SKF table when I test the security roles, but I am missing data from the pages containing information from the three tables. 

I hope that you can help with the problem, so that people only can see the information that is relevant for them.