I would like to set up section access on an app using different fields for different users. I have REGION field and an OFFICE field. Some users would be restricted to an OFFICE and others to a REGION. NB. there is a 1-M link beween regions and offices.
I have set up section access using just one field with the following:
LOAD * INLINE [
I thought the following might work but no luck. I have read on the forum a way of concatenating the fields used for section access but that seems like a more complicated way of introduced quite sophisticated access restrictions. I don't need the extra complications and was hoping for an easier way?
I've made an example for two fields, but you could put more on your app.
The first inline load would give me the section access I require (that could also be loaded from an Excel file for example) and then manipulate the section access with left join to make the full login for all users.
Just the admin is left with visibility for all fields. To enter with the admin login,