I have a database where have following 2 tables one name 'article'

code article ld_price dc_price pr_price
--------------------------------------------------
001 Shirt 10 20 25
002 Pant 15 25 35

Another is name 'type'

code type
----------------
001 LD
002 DC
002 PR

I have form where have following filed

article
type
price

I want that when I input in article textbox code 001 then onchange event textbox will get 'Shirt' if I input 002 then it will get 'Pant' from article table And when I input Type textbox code 001 then onchange event textbox will get 'LD' from type if I input 002 then onchange event textbox will get 'DC' from type and last when Price textbox onfocus then price will be show in text box by matching Artcle and table. EX. If Article is Shirt and type is LD then Price will be ld_price 10 and if it is Shirt and DC then price will be dc_price 20.

please solve the problem I am very pleased if anybody solve this problem