Dynamic Menus - Using multiple dropdown boxes
I was wondering whether someone could help me with the following :
So what I would like to do is :
[All data is held in an MS ACCESS or SQL 2000 Database]
- create a form on a page with in the first select box the country name [eg. Belgium, UK, France, ... located in the coutnry table of the DB]
- the second box is not displayed as long as nothing is selected in the first box. It will hold the cities of that particular country [eg. Brussels, London, Paris, ... located in the cities table of the DB]
The difficult part : THE PAGE MAY NOT SEEM TO RELOAD AT ALL.
The database access would go through ASP.
I already tried making something similar by putting all data in an array, putting the array in different SELECT boxes and to hide/show them using Cascading Style Sheets. However, there is still no limit in tranfsfer to the server, and it will take all data from the database and load it in memory.
Can someone please help me out ? Does this all make sense ?
If so, you can still come over to Belgium, I'll buy you a fresh, nice beer !