Restrict app usage. Security and access expressions

Howdy! I think I asked for too much in my original Question for this, so I eliminated all but the most crucial part here. Thanks for your patience & help!

I need help with a security or access filter expression for my Club Meetings app.

My Tables are Clubs, Members, Meetings. I have an "Active Members" Slice with only members where "Active" is in their [Status] column in the Members table. Members table also has an [Access] column that will be either "User or "Admin." Members table is Ref-ed to Clubs, Meetings table is Ref-ed to Members table & Clubs table.  There will be many clubs, many members & many meetings. [_ComputedKey] is the Key column in all 3 Tables.

I need to:

  1. Limit app users to only be able to see data pertaining to their Club, based on [Club] column in their row of Members table.

Thank you very much!

0 6 317
6 REPLIES 6
Top Labels in this Space