going to a layout based on id and password

[lesterd]

I am still using FMP 6 and Server 5.5

I have 800 people divided into 3 groups. Each group is has a number designated to their group in a field called “reged” Group one’s number is 55, group two’s number is “99” and Group three’s number is “4”.

I have 2 layouts in the database. I want group 1 (the #55s) to got to layout 1 and group 2 (the 99s) and 3 (the 4s) to go to layout 2 when they login. I also want to find and show only the people in their group when they go to the layout.

Basically if someone from group one logs in with their password “reg191” which allows them only to see the people with the “55” in field “reged”, I want the to go to layout 1. And if one of the other groups logins with their passwords (Group 2s password is “esl99” and group 3’s is “sped4”) I want to find the people in there group and go to layout 2.

I have already set up the limit to part in the password for the field “reged” but if the first person showing up in the layout is not in that group I am getting a “no access” in the many of the fields.

Thanks for you help.

Lester