Hello there

Let

First of all passwords are not directly tied to field or layout access. Passwords control access to "Groups" and "Groups" have privileges to access fields and layouts.

Passwords <--> Groups <--> Layouts, Fields

To accomplish what you wish, you will need to create a group for "no password" which is not allowed access to the "Staff" layout and to a global number field let's call gAccessTest.

As part of your Go to Layout script (you'll need one) for the "Staff" layout, you will need the following test.

Set Field [gAccessTest, "1"]

If [gAccessTest = 1]

Go To Layout ["Staff"]

Else

Show Message ["You must enter with a password to access this information", "OK"]

End If

What this script segment does is try to write a 1 to gAcessTest. If the user's password doesn't allow this, the test for gAccessTest = 1 fails and the user is shown a dialog box instead of being sent to the Staff layout and seeing "Access Denied". -bd

Or you could just put a script step that uses the "Status(CurrentGroup)" function to determine if a "Show Message" is necessary.

The "Groups" format is one of FMP's kludgier features, and the "Status(CurrentGroup)" function is even more so, because you have to list EVERY combination of possible groups, and it's a pain, but so far it's the simplest method.

HTH,

Dan

Status(Current Group) is a better idea. I was having a FM flashback... -bd

You mean like "Anybody who can remember FileMaker II wasn't really there." ;-)