Hey everyone.
I'm creating a new form that have a few fields wich is filled by external datasource, in this case SQLServer 2k5. The problem is, i need to filter a drop-down box list from another drop-down list box selected value and i have no idea how to do that, since i can't create any filter in datasource properties of this dropdown 'cause "filter is not compatibility with web form..."
My database is something like that:
dbState
id - Name
1 - São Paulo
2 - Rio de Janeiro
and dbCity
id - Name - idState(foreing key)
1 - Guarulhos - 1
2 - Santo Andre - 1
3 - São Paulo - 1
4 - Rio de Janeiro - 2
5 - Angra dos Reis - 2
....
Is there any way to select a State and automatically City's dropdown filter the citys of selected state?
(sorry, if my english is not good enough... i'm just learning yet and i'm giving my best shot! =D)
Thx anyway!
cya!
Filipe de Campos Cavalcante
IW Developer!