JoeHargrave
6 years agoQrew Trainee
Report Filtered By User On A Different Table
The primary table on my app is 'Events'. The Events table has a child table 'Positions', which joins to another parent table called 'Staff Members'. Essentially, the Positions table is a middle table that joins Staff Members and Events in a many-to-many relationship. Positions defines the job description, other notes, compensation rate, etc.
On the Staff Members table, each record has a 'user' field, connecting the staff member to their user / login for the app. So I can easily create a report filtering Staff Member records by the 'logged in user'.
Here's where I'm stuck. I need the Events record to be visible to the Staff Member, only if they are connected to it via a 'Position'. I have a couple user fields in the Event record, and it's very easy to only allow those users to view Events they are associated with. However, since the User Field for the Staff Member is a couple tables away, I'm having difficulty figuring out how to allow those Staff Members, when they log into the app, to see a report on their home page that contains a table with all Events where they are associated via a Position.
I feel like I'm missing something easy here, and if so, please forgive the dumb question. Any help would be greatly appreciated.
------------------------------
Joe Hargrave
------------------------------
On the Staff Members table, each record has a 'user' field, connecting the staff member to their user / login for the app. So I can easily create a report filtering Staff Member records by the 'logged in user'.
Here's where I'm stuck. I need the Events record to be visible to the Staff Member, only if they are connected to it via a 'Position'. I have a couple user fields in the Event record, and it's very easy to only allow those users to view Events they are associated with. However, since the User Field for the Staff Member is a couple tables away, I'm having difficulty figuring out how to allow those Staff Members, when they log into the app, to see a report on their home page that contains a table with all Events where they are associated via a Position.
I feel like I'm missing something easy here, and if so, please forgive the dumb question. Any help would be greatly appreciated.
------------------------------
Joe Hargrave
------------------------------