I'm building a db for a statewide teacher organization. Most of the maintenance will be done at a central office; however, I'm trying to write a script so that individual teachers can log in & access only their record so they can update address changes, etc. Since we already have their SSN's on file, I'm trying to let them use the last 4 digits as a login, using the Right function script step. Here's two approaches I've tried & the problems I've encountered:

1. Using a generic account name (i.e. "teacher") which takes them to a login page where they enter their 4 digit ID. My problems here are (a) if I use a "Go to Record/Request/Page", how to limit the found set to just their record; (: if I use a "Perform Find", I can't seem to find the correct syntax for the find request.

2. It seems simpler to use the last 4 digits as the account name with a generic password, then use Get(AccountName) to direct them to their record. But I have thousands of potential users--I can't set up an individual account name for each of them. Is there a way to have some type of "wild card" account name with a single permission set, then use Get(AccountName) to find the record?

BTW I'm hosting this with FM Server Advanced--the teachers will access their records using IWP.

Any advice appreciated--thanks.

Jerry

I am not very good at this but it seems that you will have to create two areas. An area to allow a creation of a user and your file. Pro7 allows you to control a lot of what the creator and administrator and also guests can do. But to do that, each teacher will have to have their own login account with their permissions set. I don't know excatly how to do this, but that is where you will have to go.

Fenton answered a very similar question recently (#134585). Create an unstored calculation field, text result, = Get (AccountName). Create a self-join table occurrence, with the relationship from the above field in the base table out to the user field. Then script: Go to Related Record (GTRR) ["relationship", Show only related].

Thanks for the help--may be a few days before I get back to this problem, but I think you guys have put me on the right track.