Does Security Filter on Parent Records, Filter Child Records ?

In order to improve the performance in one of my apps... I'm Using security filters in almost all of my tables. But I get to this question I donยดt know the answer...

I have a child table with a lot of records, But I only have the securitu filter on the parent table. Do I need to implement a security filter on the child record as well ?

If so, How can I do it with the same formula as the parent ?

Solved Solved
0 3 53
1 ACCEPTED SOLUTION

Yes you need it. But because you have the relationship already, you can write it like IN([ParentID],Parents[ID]). It means if the parent is filtered, its childs are filtered as well.

View solution in original post

3 REPLIES 3

Yes you need it. But because you have the relationship already, you can write it like IN([ParentID],Parents[ID]). It means if the parent is filtered, its childs are filtered as well.


@AleksiAlkio wrote:

 IN([ParentID],Parents[ID]).



Perfect !!

 

Thanks

You're welcome!

Top Labels in this Space