HB

Constrain Omit problem

Discussion created by HB on Dec 17, 2015
Latest reply on Dec 19, 2015 by HB

This is killing me.

 

I want to narrow a found set in my script after doing a Perform Find. The results don't make sense.

 

When I run the following:

Filemaker1.JPG

the found set includes records with a Product::Combined Price WO that is empty.

 

But, when I run the following:

Filemaker2.JPG

which is part of the previous constrain set, it does not include records with the empty value - (which is what I want!)

 

Why doesn't it work with the additional omit statementys in the same set??????

 

Thanks in advance.

Outcomes