Specified Find Requests

[pjdodd]

I have little problem when specifiying find requests to omit records on a found set.

In the Specified Find Requests dialog box, I can easily input the field to match a specific number, literal text and all that jazz. What I need to do is have the cirteria be field data from a global field (that changes now and then). Ive tried every combination I can think of and it doesnt work. I can set the criteria to be the actual variable in the global field but I cant get FIlemaker to actually look at the field contents.

The online help is pants (no surprises there) and ive only ever seen examples where criteria has been a specific number or text. Can a Specified Find Request involve looking at the content of a field?

[transpower]

Following a Find script step you could use Set Field (by calculation) to hold the value of your global field, and then perform the find.

[-Queue-]

Dynamic find data must be entered using

Enter Find Mode [ ]

Set Field

Omit (if necessary)

Perform Find [ ]

It cannot be entered using a stored request.

[pjdodd]

Thank you -Queue-!

Your idea has worked: entering find mode, setting the field data and using the step Omit works. Quite why the stored request cant be dynamic is beyond me.

Thanks