I have a database that I only want certain people to be able to run a script that will modify this one field. Is there a status function that will return what password was entered upon entering the database? When I created the passwords, I did only give access to the field to the passwords that I want to be able to modify it. Read only access to everyone else. But I would like a nice way of letting the users know that they cannot modify that field. I would rather not leave it up to FMP. I was hoping there was something similar to the Status(CurrentLayoutAccess) function but have it on the field level or return what password was entered. I would then create the script that will modify the field and put an If statement at the beginning of the script to see if they have enough permissions to run the script. Am I making sense? If you have any input on this I would appreciate it.

Thanks,

John

You need to create groups and then associate a password with each group. Then you can use the Status ( CurrentGroups ) to see what groups are associated with the password that the user logged in with, and then use this to do your other functions.

Kurt,

Thanks for the input. I did what you suggested. I have 4 passwords and 3 groups. ONe of the passwords is the admin password, two of the passwords are associated with one group, the last password is only associated with the last group. It has limited privileges. What I did to see what groups FMP thinks each password is associated with is I created a calculation field with the function status(CurrentGroups). When I log in with the password that is supposed to be only associated with the last group, the field shows all 3 groups. What would cause this to happen? When setting up the access privileges for the first two groups I have the bullet point greyed out for the last password. Which should mean that it is not associated with those correct? I must be missing something here.

Thanks,

John

You either have your groups setup incorrectly or are logging in with a different password.

If you set this up in a calculation, make sue that it is UNSTORED or else you'll get the results from when you created the field.

I don't know what it was but it works now! I did forget to make the calculation unstored, changed it and it reflected the groups correctly. Not quite sure what made it work all of a sudden but thanks for your help Kurt.

John