Jump to content
  • 0

Structure Help



Please Disregard. Thanks



HI all, and thanks in advance for the help (and apologies for the length).


I am making a political campaign management system that will track volunteers and voters (primarily). There will be an unknown number of candidates I will support (the more the merrier), but each candidate will have four user groups, plus there is a fifth system admin group that will be able to access everything. Candidates and their volunteers will be able to search for individual and groups of voters to flag them as possible voters or volunteers.


I only want each candidate and their respective volunteers to have access to voters in their district. Of course some candidates will need to access the same voter because of districts inside of each other (think a House of Representatives running in a part of a state where a Senator is also running state wide).


So far I have created folders for the DataForms as they relate to my user groups, but I get a little turned around on how to filter results of their search. Each candidate is in a Candidates table and has a unique ID. Each voter record has multiple possible fields that can be chosen (city ward, county ward, state house, state senate, etc). My first thought was to give each candidate a "District" field and put whatever the matching data was and then use RLS to match to the right field, but since you have to pull from the authentication table, does that mean I have to put that data in for each user in the authentication table? I'm just a little bit turned around on this. Thanks!

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...