Please HELP with three ComboBox.

[jpdragon]

Can someone please help me with this. I am try to work with three combobox and very frustrated.

ComboBox 1 - Click to Load Region (West, Central, North, South)
ComboBox 2 - Display the State according to ComboBox1
ComboBox 3 - Display the City according to Combobox2
ComboBox 4 - Display Agent Name

Example:
ComboBox 1 - Click to Load Region (West)
ComboBox 2 - Display the State: CA, WA, NV, UT, OR, etc..
ComboBox 3 - Display the City: Los Angelos, Phoenix, Las Vegas, etc...
ComboBox 4 - John Doe


Database Sample:
West - California - Los Angelos - John Doe
South - Florida - Orlando - Jean Smith
North - New York - Manhattan - Bill Cosby
Central - Ohio - Chicago - Michael Jordan

Please help me.

Thank you

[jassing]

you should use a database with your options so you can populate the next combo box based on the selection of the 1st.

[jpdragon]

Jassing,

Can you shed some light? I am not very good about database? What should I do?

[jassing]

if db's are not in your game, probably using a set of if/elseif/endif statements to react to the choice.
I would disable all bu tthe 1st combo. then as they select the 1st, populate the second combobox (Clear its contents 1st) with the values and enable it.... repeat ...

[jpdragon]

Jassing,

I put this code onShow to populate data for the first combobox.

-----------Start Populate Address ---------------
tRegion = TextFile.ReadToTable("AutoPlay\\Docs\\EMS\\ALLEMS. txt");
count = Table.Count(tRegion);

for counter = 1,count do
pos = String.Find(tRegion[counter], "|",1,false)
IpAddress = String.Mid(tRegion[counter], pos+1, -1);
MarketName = String.Left(tRegion[counter], pos-1);
result = ComboBox.AddItem("ComboBox1", MarketName, IpAddress);
end

How do I make to populate data to the second combobox if the first combobox is selected?

[jassing]

How do I make to populate data to the second combobox if the first combobox is selected?

Similarly - except you reference "Combobox2" instead of "Combobox1"