hi people!

I currently breaking my head over an issue, i could use some help!

- i have 3 comboboxes: combobox1 (list of country's), combobox2 (list of
company's), combobox3 (list of city's)

every possible combination of value's from comboboxes have a code.

my question:

what is the easiest way to get this done? their are 5 value's in combobox1,
3 value's in combobox2 and 6 value's in combobox3.

combobox1.value & combobox2.value & combobox3.value = combobox4.value

the thing is, combobox4.value = has not to be the value's from combobox
1/2/3 but a code that is decided by the value of combobox1/2/3. this value is
a code that is decided already by my boss, so it cannot be random.

for example:
Combobox1 = UK
Combobox2 = Microsoft
Combobox3 = Londen
Combobox4 = 12345

or

Combobox1 = UK
Combobox2 = Microsoft
Combobox3 = Manchester
Combobox4 = 55554

my english is not very good, i hope u understand my problem!

kind regards,