Hello, I'll let you know my problem first then what I need.

Problem: I have several users with functional layouts (ie editor, artist, etc). I want the user to login and see only their layout (done), but I want it to only see the fields with their name (done). The problem is that even though they can only see their records, they can see the fields that say "no access". So what I want to do is have them login and when they login it does a search on that specific field with their login name and it finds only those records. It's kind of complicated. I did it this way because I have no clue how to make a database relational. ha ha. But it works! I just need to find out how to perform the find command with their user name when logging in and have it work both in the web sharing and in the normal network sharing.

Thanks!

Rebecca

Excellent. I figured out how to get the script to run in the File Options menu.

Now I just need to figure out how to automatically put in the user name and continue the script without user intervention in the find command.

Try:

get(accountname)