AnsweredAssumed Answered

Referencing a field with a value stored in another field

Question asked by TurtleKoala on Jun 14, 2011
Latest reply on Jun 14, 2011 by mgores

Title

Referencing a field with a value stored in another field

Post

I'm trying to omit records that meet the criteria

Main::gFund>Global::gInvestmentAmount.

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

Main::FundA>Global::gInvestmentAmount

and if the value stored in gFund is "FundB" I want it to evaluate as

Main::FundB>Global::gInvestmentAmount.

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

Main::Other>Global::gInvestmentAmount

I might be able to figure this part of it out depending on how you would accomplish the first part of my question.

Outcomes