Referencing a field with a value stored in another field
I'm trying to omit records that meet the criteria
gFund is a field in Global, so I know that this will not work.
For example, if the value stored in gFund is "FundA", I want the inequality to be evaluated as
and if the value stored in gFund is "FundB" I want it to evaluate as
Is this possible, and how would you do it?
Also, I want to do a check to see if the value in gFund is part of a certain value list, and if it is not I want the inequality to evaluate as
I might be able to figure this part of it out depending on how you would accomplish the first part of my question.