January 13, 200521 yr 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?
January 13, 200521 yr 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.
January 13, 200521 yr 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.
January 14, 200521 yr Author 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
Create an account or sign in to comment