[Message Deleted]

[teja murali]

[Message Deleted]

[Mycroft Holmes]

You need to be a little more specific and generous with information when asking a question. I would be nice to know what type of control you are using, I will assume a combobox. Have you tried searching for a solution - this is a VERY common requirement and there are plenty of examples. Basically you bind filter of the city combo to the selected value of the country combo, repopulating the city combo in the onselected index change event.

[Blue_Boy]

Something like this: select * from cities where stateid in (select stateid from states where statename='statename')

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com