I have a phrase that pops up in red on our work order that reads " Inventory in stock " when the condition is met.

Why is the condition popping up in the FIND mode?

Because the condition is met?

What is the condition?

You can add criteria, like Get(WindowMode) = 0 to get it to go away.

Find mode = 1

You can also describe a second condition, and instead of it being equal = use the not equal ≠

And have the text be colored the same as the Background color.

HTH

Lee

-Condition is "Workorder number = Inventory number"

-Have Filemaker 9 - I have No "Get(WindowMode)" Function

-The does not = did not work, but lead me to use a second condition with a formula of IsEmpty(Workorder number) with same color used as background

(sense its in find mode its empty) This worked! Thanks guys!

Edited November 5, 201015 yr by Guest

Have Filemaker 9 - I have No "Get(WindowMode)" Function

Of course you do.

Hi could you elaborate ? I did not see the "Get (windowmode)" in the pull down list inside the calculation dialog box

Edited November 9, 201015 yr by Guest

Select "View: Get functions" and scroll down. If you have selected "View: all functions by name", you won't see any of the Get() functions - only a "Get (flag)" placeholder.

Thanks - got it! Should have know this too. Been a while since I worked on development - usually busy being a production supervisor in a print shop I happened to dabble in FMPro and created our database here in the shop back in 19?? Appreciate everyones help!