Hi All,
I am struggling with section access and was hoping some guidance to resolve my issue.
The highlighted fields all appear in a CLIENTMASTER table and below is an extract from my temporary section access file ( which does not work ). I say draft as the final version will use NTNAME rather than USERID and PASSWORD.
An employee can either be a "Servicer" - CLI_USERIDSERV or a CLI_USERIDINBR or both.
The intent is to grant access to the data where he/she is either the Servicer or the Broker of an Account irrespective of whoever the other colleague (Servicer/Broker) might be.
I also wish to grant ( in this case ) access to all clients in his department.
| USERID | PASSWORD | SERIAL | ACCESS | NTNAME | CLI_DEPARTMENT | CLI_USERIDSERV | CLI_USERIDINBR |
| ABC | 123 | * | USER | * | * | ROCHEB01 | * |
| ABC | 123 | * | USER | * | * | * | ROCHEB01 |
| ABC | 123 | * | USER | * | DEPT1 | * | * |
| XYZ | 123 | * | USER | * | * | FARREB01 | * |
| XYZ | 123 | * | USER | * | * | BRADYP01 | * |
Could I please request some assistance with my challenge.
Many thanks,
Rob
.png "Luminary Alumni"){kind=icon}