hello guys and girls. this is my first time posting here so bear with me.

i've made a simple database for checking kids in that I had down just fine. but due to privacy constraints i'm best off making separate layouts for each type of user/privilege set. and since this is all outside and paying for FM licenses for such a small thing is far form worth it. its all done on iPads or iPhones (depends on what we have for a given week). so this is where i need your help i need help designing a start up script that puts them on the right layout based on what they log in with and what device they are using at the time.

I can get it to go to layout based on device and I can do it based on user (like it is right now) but I can't get both to work. I've tried a nested If statement both device > user/privilege set/go to layout based on access and vice versa. my guess is I'm missing something small or am I wrong about the whole nested If statement?

well it looks like I can't upload that database so here is a PDF of the script

Startup script Copy.pdf

the script that i messed around with is form here:

http://fmforums.com/forum/topic/83749-automatically-go-to-a-layout-based-on-userusername/

Thanks waltervargasnoia for getting me closer to my goal.

Rather than based on the account name (which will change as users change) base the logic on the privilege set name. There should be a different privilege set for each user *role* anyway.

Is this script set to run with full access privileges? If it does then that's the problem.

Also, the script sets a $$global variable at the start. Is this value used elsewhere in the solution? If not then make it into a $local variable.

I know that it is better practice to use privilege sets over user. but with this is doesn't really matter, on the other hand i would like to learn the right way. and there are privilege sets for every role (1 for every user in this case)

i do not have that set. I've been going through the VTC tutorials, and haven't gotten to that part yet (explaining the implications of running a script with full access, i do know that bypasses the curent user's privilege set).

I also haven't gotten into global vs local variables, and as far i know they aren't anywhere else. the only global I have in the solution is a "iOS quick find" (borrowed form the starter solutions).

I'm testing all the users now with some variables and i will port results when i'm done.

Right now, to get you started, duplicate the current privilege set and name them for each role, then set the user accounts to the appropriate privilege set.

Now use the privilege set name in the calculations, not the account name. Done.

When you get time, you can then customise each privilege set to better suit the roles.