drop down list

[Former Member]

Hi VC Gurus,

This might be a simple question but I am fairly new to VC. I would like to create a drop down list with the following values.

AAA Brazil

BBB Colombia

(AAA BBB) South America

CCC Canada

I think I might be going about this wrong. What I want though is to be able to filter by either country or continent. If this is possible and if so could someone please provide an example or explain what to do.

thank you,

Joseph

[Former Member]

Hello Joseph,

I think you can acheive your goal using a simple mathematics trick.

For each continent we will give a prime number:

Europe = 2

Asia = 3

Africa = 5

America = 7

Australia= 11

Now, each country gets a unique number acording to its continent:

Country in Europe = 2^n (n>1)

Country in Asia = 3^n (n>1)

This way you hold the "extra" data. If X is the value for one country and Y for another,

then if X/Y = integer they are at the same continent.

Hope this helps,

Shay