Find Records with

[Mike B.]

I'm new to the forum, and am frustrated to no end. For quite some time now, I've struggled with this problem.

First, here is my script:

Go to layout ["School Finder"]

Enter Find Mode [Pause]

Perform Find [ ]

Go to Layout ["Rating Entry"]

Perform Script [sort by Inst Code/Name"]

Here is the way it works. After clicking the button that starts the script, it goes to a layout with radio buttons by school names. The user clicks a radio button then clicks continue, and it takes you to another layout with just those records that contain that school and then sorts.

My problem is that when more than one school has the same name with a variation, it finds all those schools; such as Rusk, West Rusk, North Rusk, etc. When you click Rusk, all records with Rusk in it show up.

I know I need to insert "==" into the field somehow in the middle of the find. How do I do that?

Also, it would be nice for the user not to have to click continue. Is that possible?

[mr_vodka]

You need to set the field before performing the actual find.

Go to layout ["School Finder"]

Enter Find Mode [ ]

Set Field [school; "==Rusk" ]

Perform Find [ ]

Go to Layout ["Rating Entry"]

Perform Script [sort by Inst Code/Name"]

When you use a field value with it, it will be something like:

Set Field [school; "==" & SomeField ], where SomeField's value was "Rusk"

Edited January 23, 2006 by Guest

[Mike B.]

That did it! Thanks!

I swear I've tried that and it didn't work.

It ended up looking like this:

Set Field [uIL SE::School; "==" & UIL SE::School]

Getting the users chosen school in there was the confusing part.

Now, can you figure out the other problem...proceeding with the script after the radio button has been chosen without having to click "continue".

Mike

[mr_vodka]

What I probably would do is instead of going into Find Mode with a pause, I would instead stay in browse mode, let the user select the radio selection, and then have a button that runs the script without any pauses in find mode. This was there will be no Continue button to hit.