Security filters for Members in Clubs and Meetings in Clubs

[Stephen_Mattiso]

Howdy, I have Tables for Clubs, Members & Meetings. Need help with Security Filters.
I need to restrict Meetings Table to only display Meetings for the Club the Member/User is in.

I also need to restrict Members Table to only display Members who are in the same Club as the User/Member.

Thank you very much!!

[Steve]

How are the tables related?

[Stephen_Mattiso]

Since you like the Visual explanation Steve, I’ll add this image in case I don’t explain it correctly. In fact, I’ve already screwed up my question above, sorry. The Clubs Table is not even added to the App yet. When I get this, I’ll be able to use same formula in Clubs Table.

So currently, I just have Meetings Table and Members Table. Members just have a [Club] column. In Meetings Table, I have Roles like President, Time Keeper, Greeter, etc that are each Ref’d to Members Table.

[Stephen_Mattiso]

And I have a Meetings Slice set up, but I’m not sure that I need it. Sorry to confuse!

[MultiTech]

I would make use of a Current_User (Slice), then use that in your slice as the criteria.

[User_Club] = any(current_User[User_Club])

something like that.