Adding an Operator and Expression 2 Dependencies

Which values are valid for the Expression 2 type (Expr2Type property) depend on the value of the Operator property.

The following table describes which Expr2Type values are valid with which values of Operator.

Operator	Expression 2
equal to not equal to greater than not greater than less than not less than	Constant Field Expression Subquery Prompt
Exists not exists	Subquery
Like not like	Constant (with wildcards) Prompt
is null is not null
in tree not in tree	Tree Option Tree Prompt Option
Eff Date <= Eff Date >= Eff Date < EffDate >	Field Expression Constant Current Date
First Eff Date Last Eff Date
in list not in list	In list Subquery
Between Not Between	Const-Const Const-Field Const-Expr Field-Const Field-Field Field-Expr Expr-Const Expr-Field Expr-Expr