i have 3 combobox(item name,brand name,price) but item name can be several brands and each brand has different price. now i want to do that, when user select item name using first combobox then it shows it's appropriate brand in second combobox. and when user select brand name using second combobox then it shows it's price in third combobox.
suppose i have item jeans and it has 5 brands(lee,levise,coutons,cotton county,liver pool) each brand has it's different price(999,1099,1599,2000,2599).
when user select brand=jeans using combobox1 then it shows 5 brands(lee,levise,coutons,cotton county,liver pool) in combobox2 and when user select brand name lee then price should be shown 999 and when user select liver pool then price should be shown 2599 and so on..... in combobox.
what should i do??????
plz help me
thankyou......