Trying to Set Field as Calculation of Global Field
In the following script I am trying to perform a find based upon the contents of Field 1 being less than my global gField 2. This is to select all account that have sales less than a global field with a drop down list of values (1000...50000). The idea would be for a manager to be able to select all accounts with sales ≤ X and a sales rep = Y.
Unfortunately when I execute the script, I get a returned value of no records, however if I were to go into Find mode and physically select a sales rep from the sales rep field, and set ≤X in the sales field I would get the desired results.
I would appreciate any help.