Hi, I guess the answer is "no" but I thought I'd ask anyway ... I would like to have a value list (displayed as pop-up menu) with items populated after a query using the ExecuteSQL function. ¿Any way of achieving this? thanks!
If you create an unstored calc field which uses the List functions in combo with an SQL function, you can generate a list of values in that field for retreival only when needed, and reference that field as the source of your values to appear in the list.
Thank you very much for the link jbante, the "Magic Value lists" trick did exactly what I wanted
Sorry for the delay in replying Stephen. Thank you for your suggestion, but I wasn´t very successful, not sure if I'm missing something. I have attached an sample file, is this what you mean?
Retrieving data ...