goto specific record when loggin in

[Pescador]

Right now I have the database set up to only allow users to see records according to username. What I am hoping to do is when they login in I want the it to open up their employee page. I have tried a couple of things but no success.

So if their username is sunshine then when they login into the database it takes them the sunshines employee page. I tried creating a script so that under file options I could have it run the script but I am not having success.

[Ender]

If you store the username in a field in the Employee table, you can set up a relationship from a globally stored gUserName and the username field in Employee. Then have the startup script populate the global with the current username, and use a Go to Related Record[] script step to jump to the related record.

[Pescador]

In fear of looking a little dumb. I have tried to use your suggestion. I am not completely clear on what you are saying. Is it possible to put together a short example of how it might work. Thanks.

[mr_vodka]

As Ender said, create a global text field and then on the opening script, store the username in this field.

Create a relationship between this global field and the user name in the Employee table. We are assuming that each Employee record has a user name associated with it.

Now again as part of the opening script, you could use a Go to Related Record Step based on the relationship you created to the Employee table occurence. This will show each user's emloyee record.

[Andragoras]

How would this work for records that have already been created? I created a field that captures login info, but previously entered records don't display who created the record. Hence a user logging in won't see anything they did in the past.

Ideas?

Edited August 6, 2007 by Guest

[Vaughan]

You'll need to add that information to each existing record.

[Andragoras]

Sounds like fun. Thanks!