Dropdown cascading problem

[haimbeyhan]

Hi,

I have 3 dropdowns (city, district, neighborhood) with cascading
There is no problem with city dropdown. I can see the list and choose one.
Once city is chosen the 2.dropdown gets populated with the districts that belong to chosen city and I can choose the district.
Once the district is chosen, I see only 1 item populated in the 3. dropdown which is the value of the neighborhood.
If I delete the cascading part in the 3.dropdown, I can see the items populated but I see all the items that belong to all cities.

Is there any problem with more than 2 cascading dropdowns ?

Note: I'm using SQL Server 2008 Express in the background.

Thanks,

Haim Beyhan

[Lance Gurd]

Works for me Haim, although I am using MySQL backend.

Have you got the Method for computing cascaded choices set to <auto> (the way I have it) or explicit (can be done but more complicated)

[haimbeyhan]

I tried Auto and I tried explicit. The same problem.

[Lance Gurd]

Attached is a dialog built against the northwinds database. You will need to make your own connection string to the data to try this. The MDB (access) file should be in your MDBFiles directory located in Alphafive install directory. In my case, the default, C:\Program Files (x86)\a5V12\MDBFiles.

customers.zip

Once your connection string is working, open the dialog, edit all the controls to match your own connection, then go to working preview and choose UK, London, or USA, Portland both of these should give you multiple choices in the customer dropdown. There are a few other countries with multiple choices as well.

If this doesn't work at your end I am at a loss, because it works here. If it does work, contrast it with a)your data structure you are querying b) your dropdown box syntax

[haimbeyhan]

Thanks for your reply.
I copied the zip file and I saw that it's working as you said. But this was ux component.
I created then a grid with a detail and used the same data and it's not working there.

[haimbeyhan]

Pls ignore my previous post. It's working also with the grid.
I just tested with the 1.record which had only 1 customer name in Germany,Berlin city.
Now the difference with my case is, that I'm using different tables for each dropdown and I'm using id's to store the value and names to show in dropdown.

[Lance Gurd]

It's working here!

[Lance Gurd]

It should still be do-able, you would need to use explicit for the method of computing the choices though. Does your neighborhood table have the district field formatted as an INT field?