hi...
i am developing a project in C#.Net
i am using sql as the database
it is a windows application
now
in the form there are say two comboboxes
say....1st combobox named PersonName
2nd combobox named Designation
both are connected to the database..thus values are coming in them from the database
what i want is that when i select a person from combobox 1...the designation of that person in the database should be reflected in combobox 2....and then whenevr there is a change in the personname....the designation in the 2nd combobox should change according to what is in the database....

i hope somebody could help me with the problem...

thanks

vicky