DroidDB Tip of the Month
DroidDB® Tip for November 2014
Looking Up a Value From Within a Macro
While a macro is running, is it possible to lookup a value from another table? Yes, this can be done, but it is not obvious how. Here's what you have to do:
On your form, create a lookup control that does the lookup. For example, you might create a lookup control that saves the value retrieved into @var(56).
Then, in your macro, when it's time to do the lookup, do an OPTION | RECALC. @var(56) will be set to the lookup value.