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:
Section Access;
LOAD * INLINE [
ACCESS,USERID,OFFICE
ADMIN,EMEA\test,
USER,EMEA\test_restricted,Cambridge
];
Section Application;
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?
Section Access;
LOAD * INLINE [
ACCESS,USERID,OFFICE, REGION
ADMIN,EMEA\test,,
USER,EMEA\test_restricted1,Cambridge,
USER,EMEA\test_restricted2,,NorthWest
];
Section Application;
