Macro or something similar

[#1]

I have a list of countries and I want to create a list (or something else) so that when I click the name it selects a set of countries.

Example: a list of regions (north america, south america...) when I click north america I want it to go to my table and select canada, us and mexico.

How do I create this list?

or those buttons?

or whatever I need to create to make it happen.

[Siva_Sankar]

I didnt get any clear idea. See the attached qvw file.. and let me know more details to help you better. Regards. Siva

[sushil353]

Hi,

Please find the attached app...

HTH

Sushil

[prasad_dumbre]

Hi,

From What I understood from your post is, You are having a list of countries, now you want to group them based on something such as Continet. So, if you select Asia then countries in asia should get selected like that

If it is so, and you dont have grouping field (Continet in my eg.) then you simply create a excel or inline table having two fields First, Countries and second Continent. Now using applymap you add that second column required for grouping in your table.

Hope it helps. Reply in case of query . . .