I am trying to use the currently logged on username to do a find. I have added the currently logged on username to a field, then created a script to look for matching name in another field, and display records. When I execute, the user name disappears from the field and I get the "no matching Records" message. Is there another way I can do this to make it work?

Can you post your file?

Excuse my ignorance, but do you want me to post the whole FM file? Or just paste pertaining parts?

If you can just paste the script that you're using to do the find, that might help. But it might ber easier if you zip and post the file so someone else can reproduce the behavior you're observing.

It sounds like your script might not be in the right mode (browse vs. find) when you're performing the find. But seeing the script or the file would make the problem easier to diagnose.

Here is the file. The layout is "Buttons" and the Script is called "Find Jeffs Tasks"

mytasklayout.zip

Your script won't work because you put a field name in the find request. In a fixed find request you can only put literal values. I've added a new script to your system and put a couple of new buttons on the button layout. The top one allows you to login as different users to test the find. I added accounts for Li and Dana (me) None of the accounts have passwords.

Let me know how this works for you.

Dana

mytasklayout.fp7.zip

Dana,

Ah I see (said the blind man). I didnt know I couldn't use field names in a find request. As my profile says I am very new to FileMaker.

Your script does just what I wanted. Now I can analyse each part and see how to do it myself.

Thanks alot for your help,

Jeff

BTW Cute Baby...

Dana,

Did you set up a differnet script for each user? If not how is the user name calculated into the find?

Thanks, Jeff