How to get values according to selected listbox?

[#1]

Hi All,

In my application i am using QVD files. I have written queries like:

select * from Continent.
select * from Country.

I have 2 list boxes in sheet for Continent and Country.

As per the requirement i need to change the 2 query in QVD file:

Select * from Country where contient = <Selected listbox value on the QVW sheet>

How it can be done.

Thanks in advance

[#2]

You will need to make a macro, to store selected valeu on listbox, in an variable, then use variable on script. Select * from Country where continent = '$(Variable)'; But, it is strange. I believe you make a very specific aplication.