The above lookup first worked for me in ACT 2010. A later "upgrade" of 2010 made it quit functioning. I was told by the ACT Advantage support person that this would be fixed in ACT 2011. Well, it still doesn't work. Others have told me to use Advance Query, but that isn't as convenient or quick.
When is this feature going to start working, again?