Section Access

[mrainey18]

I'm trying to figure out a way to have regions see all branches without having to list out all the branches they can see.  If I concatenate the region with the branch ID I will get something like this "North-123".  

Is there a way to have section access for "North-*" which will include all the branches with "North-" in-front of it?  I tried doing this but it doesn't work.  Is there another way around this?

[Lauri]

As far as I know, your Section Access statement needs to list every value of Branch that each user can see. But your data load can be quite simple if every user from "North" gets to see every branch related to North. Just make Region the key field in Section Access, and then load a table with every permitted combination of Region and Branch in Section Application. That way, a user with "North" in Region in the Section Access will get to see all Branches.