I just had to pass this on! please get the example, it's simply wonderful.
=== forwarded ===
As some of you may know, John Ahn demoed the "impossible" at the ExecuteSQL "Unconference" session at DevCon last week, by casually showing an example of a conditional value list based on an unstored field.
Well, Andries Heylen of BH&A was in the audience, and on the long plane flight back to Belgium he put together a demo (requires FM 12) which you won't want to miss. And incidentally, this technique happens to use ExecuteSQL, but does not require it.