This has got to be one of those "it's so simple but the answer eludes me" questions...

I'm trying to write a script step where a part number is copy/pasted for a Find in another file, but I want to add the "==" parameter to it for exact searching... Any suggestions??

Setfield[thefieldinthefindfile;"=="&thefieldnamethatcontainsthepartNo.]

I seem to recall that the divider in 6 might not have been a semicolon. You will have to look that up.

Sorry also for the elongated names but with nothing else to go on...

HTH

Phil

Hi Phil,

It's a comma, but it really doesn't matter, as ScripMaker enters it automatically.

Hi WC,

Stay away from Copy and Paste, use a global field instead.

In order to perform a find in a second file, you will need two scripts.

I'll use File A and File B to explain it.

Create the following.

In File A, a global (I'll use [color:red]g_find).

In File B, create a relationship to File A. (I'll call it [color:green]B|A_Relationship)

In File B, create your script to perform the find

[color:blue]TheFindScript

Enter find mode

Set Field [ YourFindField, "==" & [color:green]B|A_Relationship::[color:red]g_find ]

Perform Find.

In File A, create a script with at least these two steps.

SetField (g_find, YourFindData)

and

Perform External Script [color:blue]TheFindScript.

HTH

Lee

Also, if fr some reason set field odes not work, use the insert calculated result step instead.

Dave McQueen

: Not working...

The calculation box keeps telling me it needs an operator where the comma (and I tried the semi-colon too) is... Also, I don't understand how the global field will identify the record in file A that is currently being browsed...

Could you explain?

I noticed that you have added that you are NOW using 8.5. Things have changed since the v6 days, so which way do you want the example to be written. v6 or v8.5?

(assumes the position of great shame)

I am sorry... it is 8.5...

I have been a member for a long time, and we just recently upgraded (after much prostrating and begging); I haven't changed my user preferences and they default to 6... Sorry...

(Side note) Now see... There I tried to change all that in myh last post and it didn't take...

Location: Main Index » Forum Index » Your Control Panel » Public Profile >> [color:blue]FileMaker Questions (last item on the list.)

It is a little bit hidden. I recently updated mine and it took me awhile to find the place to change it......lol

v8 has made things a lot simpler. Here is an example of using both methods.

Lee

WC_Howard_.fp7.zip