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.

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.

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.

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.

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, 200718 yr by Guest

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

Sounds like fun. Thanks!