there is a checkbox to specify a stored query with a formula. What is the formula to load a script from a global text field?
Which version do you use?
I see "radio buttons" for "calculated SQL text" and "SQL text" on FM15.
If you have stored SQL text in a global field, you can simply specify the filed name in the formula as table::field.
Thanks, it worked!
I was fixated on Lookup or other function, missed the simple!
I need this to make a dynamic query but the 256 character limit in that field slightly complicated it.
Greatly appreciate your answer.
Sent from my iPhone
Retrieving data ...