Rather than a temp table, I would define a permanent temp view for this if you can. But yes, I think this would be the best solution.
Karen -----Original Message----- From: Armin Thoma <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, Jul 16, 2014 11:01 am Subject: [RBASE-L] - UNION SELECT .... Hi I know how to use CHOOSE to show the option '--- everybody---' in addition Choose vPick1 FROM #VALUES FOR DISTINCT FilName FROM FILIALEN + UNION SELECT '---everybody---' FROM FILIALEN WHERE COUNT = 1 So I tried the same technic within the WHERE clause of a Variable Lookup Combo Box or Variable Lookup List Box - no chance. Ok, you could define a TempTab ....., but I'm sure there is a better possibility already published in the list? Armin
