Hi everybody,

I am new to Filemaker and worked through the sample files and read some threads here.

What I want to do is creating a system with three user levels.

Please let me know whether my basic strategy is ok.

I have a login file where I assign a password to each user and each password to a group.

Depending on the login I direct the user to three login layout. From there the username is pushed to a specific start file (one for each user level).

The start files open with a standard password (of course each start file has its own). By checking with a script for the open login file I (hopefully ;-) ) prevent the start file from being opened without going through the login routine. (In addition, if there were a chance to get to this file, there wouldn't be a correct username)

From this startfiles I have scripts opening all other files always pushing the username towards this files.

All other files don't use standard passwords, I let Filemaker (the start files) opening this files with the passwords with which the start files were opened.

So now I have my three groups coming from three different startfiles with three different passwords and various usernames.

All files now have three groups assigned, and I restrict access through the three different passwords to certain layouts and records.

In addition, when opening the files I perform a search through the records with the username. The user will only see the records he created and won't get the "no access" records.

What do you think about this ..... am I on track or are there to many errors in my strategy?

Thanks in advance for your help .....

gemgon

Take a look at the brillent file by Giuseppe Pupita called [color:"blue"] The Gateway available at

http://fmfiles.com/

HTH

Lee