I have a table of Users (from Authentications) with an added field for a relationship with the Organization ID.
I have a third table of Members that also has a relationship with the Organization ID.
I would like the individual users with an Organization ID to only see the Members who have the SAME Organization ID. So that any given user could only add or edit members from their own organization. Make sense?
I thought I would try to filter this in a View and maybe a little SQL... and then build a form off of that View. But it doesn't seem to work that way... Am I not seeing something or am I just going down the wrong path (i.e. there's a better way)?
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.
Question
JosephBaxter
So, here's what I'm trying to do:
I would like the individual users with an Organization ID to only see the Members who have the SAME Organization ID. So that any given user could only add or edit members from their own organization. Make sense?
I thought I would try to filter this in a View and maybe a little SQL... and then build a form off of that View. But it doesn't seem to work that way... Am I not seeing something or am I just going down the wrong path (i.e. there's a better way)?
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.