limiting user view of a layout while still having full access
I am working on a database where I have a strange problem. I have a user who needs one login that has full access to all tables and layouts. Then another that has full access to everything but viewing a certain layout.. I know that I can go to manage security and create custom privileges, but it seems to limit the access to a certain layout would also mean all options to access data from that layout would be removed as well. it's normally would not be a problem if the user was operating from a computer, however it's going to be on an iPad so just limiting the views of certain layouts and allowing another account to have full access to open any view in design mode wouldn't work. I am hopeful that there is a script that could just hide a layout from the layout selection. Currently my layouts are selected from a value list so if there is a way to pick the value list basee on user name that would work too....