Hi, is there an omit search symbol or something that can be used in that sense as my left menu is hidden in the application so the users cannot select omit from it? Not a scripted search but a regular one?

In detail: I have a find that displays a dialog box which allows the user to search the db via item code only, there is also an Advanced button which they can press and will be taken to a regular find mode and after they enter their criteria they can hit enter to complete the search or they can add more search requests. The problem is that as the left menu is hidden so that they cannot select omit. Is there a symbol that they could type in before the criteria which would indicate omit? - something like <25 where < would be an omit symbol? - I looked and was not able to find it (either did not look enough, still looking, or there is no such symbol).

Thank you.,

"Is there a symbol that they could type in before the criteria which would indicate omit?"

No. Omit is done with the "Omit Record" script step.

It might be possible to add this command to a custom menu. The difficulty is displaying whether the request is omitted or not.

Somebody post a demo file that does this.

cmd-T will give a find request the status of "Omit", but you still have the problem of seeing what the status of that request is.

An unstored calc field with a Get(RequestOmitState) will give you that status, but you'll need to build that into your layout somehow.

Or just show the Status Area when a user is in the "Advanced" mode.

A calculation field will not display data in Find mode. You can use a global field for this - if you're willing to make do with form view only + scripted switching between requests. See Bob Weaver's demo here:

http://www.fmforums.com/forum/showtopic.php?tid/70532/

That's right, you'll need to script the Omit status.

Thank you. This helped a lot. Know now hot to take care of it. Thank you.