Filter Zero Quantities

[AnthonyDixon]

I'm trying to create a portal filter to omit or include zero quantity stock lines in a related stock table that contains a quantity field. I have

created a global filter field in my main table but I'm just not sure how to build the relationship to

my stock table to get the filer to work.

Thank You

Anthony

[bruceR]

There are probably ways to get there somehow in FM9; but any chance of upgrading to FM11? FM11 portal filters are much more flexible.

[AnthonyDixon]

Not any time soon, They are a mix of 9 & 10 for now.

[comment]

Define a calculation field in the child table =

GetAsBoolean ( Quantity )

[bruceR]

He will probably want to turn *off* the "Do not evaluate if all reference fields are empty" checkbox, I believe?

[comment]

Why don't you try it and see for yourself?