hai all,

i have 2 tables 1)state
state contains stateid,statename here stateid is primary key.
city contains cityid,cityname,stateid stateid is foreign key.
2)city
now state contain 1 ap,2 tamilnadu,3 banglore.
city contains chittor 1,madanapalle 1,tirupati 1
katpadi 2 ,kanchi 2
mysore 3 ,chintamani 3

when i select the ap city only shown in drop down list
i dont have any code could you please help me any one .