Perform Find Script with a variable for criteria

[nailBnny]

Howdy all,

I've reached a bit of a dead end with an idea I want to implement in my FM7 v2 database.

Here's my situation and what I would like to do:

My database consists of multi-page forms that the users fill out. Each form has its own table due to the large number of fields required per each form. One field (Job#) is present in all tables and I've used it to relate the tables together. I

[CobaltSky]

Hello Benjamin,

It's true that the Perform Find script command in FileMaker v7 does not support the use of field values. However there are some relatively simple alternatives.

One way you might go about it is to set up your script to transfer the value(s) that you want to find into a global field prior to entering find mode, then use a Set Field[ ] comand in find mode to transfer the contents of the global field into the relevant field you wish to search on and then have the script perform the find without specified criteria (it will use the criteria entered by the Set Field [ ] steps).

That way your finds can be fully scripted, yet can also be dynamic.

[nailBnny]

Hello Ray,

That sounds perfect! I'll be the hero in my lab thanks to you!

Ben

[-Queue-]

You can also use a relationship from a global text field to the Job# field. When the job number is entered into the global, a Go to Related Records [show, gText_Job#] script step will find only the related records. It can be faster than a Perform Find too. If you have a portal using this relationship, it will immediately display related records after entering the job number and pressing Enter. So you could display all related records without changing your found set, and put a button over the first portal row that goes to the related record only if one is chosen.

[nailBnny]

That sounds like a good way to go about it. This is a great forum. Thanks

Benjamin