1. I want my ADMIN account to see all - Thats easy enough.
2. I want one of my shops only to see data about it self - How do i do that?
3. What defines where my "security is" Is it my tablename, or listbox name, or my "selcted field to make the listbox" (I have used the last one as you can see)
Example:
STAR is ALL;
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, USERKEY, SHOPNAME
ADMIN, ADMIN, ADMIN, ALL, ALL
USER, Customer1, Customer1, ALL, ALDI
USER, Customer2, Customer2, ALL, COLES
];
USERKEY is my UsersName (I know that key is dumb, but i dont have any names in data yet, so i use my key)
SHOPNAME contains all my shops
So if i want Customer1 to only see ALDI what should i do?
Should i make a secction application looking like this;
No, you do not need to map anything in the Section Access. And you don't need to create an extra table. I created a table in Excel with USERID, ACCESS, ShopName and AreaName because I wanted you to see what the source table could look like and which fields you should load from it.
All you need to do is decide where you want to keep and maintain this table: In a database? In Excel? Or as an inline in the script? Once you've done that, you need to have a Load statement inside Section Access that loads this data. And thats it.
.png "Former Employee"){kind=icon}