I have a section access data where i want to make reduction on 'BranchID' field'.Suppose I have total 60 Branches in Branch Master. As in following case, UserID 'EMP\102' has access to 3 branches thus it is written thrice. Similarly, Now if I have to give some user access to 40 branches among 60 then do I have to mention that UserID in the section access table 40 times?? Is there any simpler way.?
You can load an extra field e.g. AccessGroup where you group these 40 values in one. You can then use this field (or a combination of) to give access. N.B the field names and values need to be in capitals, so BRANCHID