I see 2 issues:
1. SALESMAN AS SalesManAppField - Section Access can only work with Upper Case Field Names.
2. The link between the "Security" fields to the "Application" fields needs to happen within Section Application. Something like this:
FROM security.xls (biff, embedded labels, table is Users$);
LEFT JOIN (AccessPermit)
FROM security.xls (biff, embedded labels, table is UserInfo$);
STAR IS *;
SalesManAppField as SALESMAN
After I implemented this solution in the app, I have been ordered to enhance it...
Now, when a user that is a MANAGER of a subset of salesmen logins in, it must see only data related to its "team"...
I tried creating a MANAGER field in the .XLS file that holds the security information, but with no success at first...
Have you or anyone following this post ever stepped upon something like it?
You can add another field, MANAGER, and create another corresponding field in your application - for example, SalesManager. Build an association between SalesManagers and Sales People (reading from Excel, for example). For those users that are Managers, fill out their MANAGER field. Then, associate MANAGER field from Section Access with the SalesManager field from your application, and it should work in the same way.
Oleg, thanx for answering!
Let me check if I got this right...
"You can add another field, MANAGER, and create another corresponding field in your application"
My excel file have two sheets (tables) to control de access so far...
USER (Access, UserID, Password) and USERINFO (UserID, Salesmen). The Salesmen is my common field with the app (just like MANAGER must become), and made it work perfectly according to the first proposal.
"Build an association between SalesManagers and Sales People". For those users that are Managers, fill out their MANAGER field. Then, associate MANAGER field from Section Access with the SalesManager field from your application, and it should work in the same way."
That's the 1 million dollar question... I don't see in which table (USER or USERINFO) the MANAGER field must be created, how must I fill it (with the managers names, or with BOOL values), and how may I create it in the app (add it to the excel file, or bring it INLINE within the app)... the Salesmen field used previously was already in the app, making everything easier at first.
I'm trying things out like you have told, but I would very much appreciate another look of yours into this matter.
Thank you so much once again!