I realize that this is a fairly basic question, and I'm one inch away from the answer. But oh that inch...

So I made a database from the foundations of the FM Starter Solutions Document Library (I've tweaked it a bunch, but the structure is the same).

It's a resume database, and many of the job titles have shared values in compound names (ie: "inspector" and "building inspector" and "terrain inspector") Obviously when I use the search feature and type in "inspector", wanting only the inspectors to come up, all job titles that include the work "inspector" appear in list view.

Now I know that if I were to type ==inspector in the job titles field this will retrieve my desired results, but I'm developing this database to be as idiotproof as possible. Any extra typing will just confuse. How can I put this exact value (double equal sign) search into the "find" script to keep it painfully easy for the users?

And I've played around already with script maker and it didn't work out, so if any helper could be as didactic and step-by-step as possible, I'd really appreciate it!

TIA

How can I put this exact value (double equal sign) search into the "find" script to keep it painfully easy for the users?

Enter Find Mode [ pause ] ... allows Users to type what they want

... here the User would hit enter to perform the find but the next step will happen first ...

Modify Last Find

Set Field [ thatTextField ; "==" & thatTextField ]

Perform Find [ ]

... this will take the User value in that field and add == to the front of it. Of course include error trapping and so forth. But using Modify Last Find is great for changing what someone enters into something which YOU want entered (using what they started with).

Edited July 18, 200817 yr by Guest

Thanks much! I totally understand the concept. Unfortunatly, it still doesn't seem to work. I think the problem for me comes when I use the setfield feature, how do I get that semicolon in there as you exemplified. Also where in the entire script do I put the commands that you recommended, right at the beginning? Again, I took this find script from the Starter solution.

Thank you so much for your patience in dealing with my oh so basic question.

NM. I just figured it out. Thank you so much! Simple but perfect. With speedy/accurate responses I'm sure to be back.