I have a query attached to a form. In which depending on the user logged in, it will need to query based on a different number of criteria.
As an example:
If user A then view Group A, Group B, Group C
If user B then view Group D, Group E
If user C then view Group A, Group E, Group F, Group G
and so no
I cannot hard code it as the number of Groups can change per person. The way I get the number of groups a user has access to is there is a table with a many to many connection. Each user can have many groups in that table. How can I code this?
** Sorry if you see this as a duplicate. I posted this yesterday but I searched by my username and the title and cannot find it.
As an example:
If user A then view Group A, Group B, Group C
If user B then view Group D, Group E
If user C then view Group A, Group E, Group F, Group G
and so no
I cannot hard code it as the number of Groups can change per person. The way I get the number of groups a user has access to is there is a table with a many to many connection. Each user can have many groups in that table. How can I code this?
** Sorry if you see this as a duplicate. I posted this yesterday but I searched by my username and the title and cannot find it.