I am building a section access dashboard and i have done several times in different ways.
Assuming I have User and Manager columns within the table i am going to use what would you think the best way to accomplish the section access dashboard giving that User can be in both User and Manager column and the manager needs access to all his/her Users.
I will try to build it and let you know if it works.. I think it will not work as I don't see how the manager can be authorized to see his/her users data.. how is the relationship between the Manager and the user is defined within section access if we are using only one column of the database.
In section access you can only have two types of users - admin and users
so your section access table will need to have (all needs to be in caps)
ACCESS, USERID, PASSWORD, [FIELD]
ADMIN, ADMIN, ADMIN1
USER, JOHN, PASSWORD1
USER, JASON, PASSWORD2
USER, GEORGE, PASSWORD3
USER, DAN, PASSWORD4
USER, EMILIE, PASSWORD5
the first three will set up the profiles for your users and assign a username and password but then you need to have a field that their access will be filtered/reduced by given the information you have provided that would most likely need to be the staff name but this needs to be in your main dataset.
ACCESS, USERID, PASSWORD, STAFFNAME
ADMIN, ADMIN, ADMIN1
USER, JOHN, PASSWORD1, JOHN
USER, JOHN, PASSWORD1, JASON
USER, JOHN, PASSWORD1, GEORGE
USER, JASON, PASSWORD2, JASON
USER, GEORGE, PASSWORD3, GEORGE
USER, DAN, PASSWORD4, DAN
USER, DAN, PASSWORD4, EMILE
USER, EMILIE, PASSWORD5, EMILE
things you need to check
a) this is in the first tab of scripting
b) you field (staffname) is all in caps and with no spaces (can use Upper(purgechar([field], ' ')) to make sure of that
c) do not use * for all just leave blank.
If you are able to send me through your QVW and let me know what field you want to filter on I can have a play and try and knock something up for you.
The isse is not within the section access table. the difference between my data model and yours is that you are filtering data on one column while i have two Users and Managers..
