Doubt in datacombo in vb 6.0

[hussainiyad]

Dear All,

In my form i,v many tables for examples

1.(Table)suppli er = SupId varchar(10) primary key,SupName(20)

2.(Table)Produc t = ItemNo varchar(10)Prim ary key,Descrp varchar(20),Pri ce float,Qty int

3.(Table)Pinvoi ce=InvoiceNo int primary key, Pdate datetime,SupId varchar(10),Sup Name varchar(10),Ite mNo varchar(10),Des crp varchar(20),Pri ce int,Qty int

i created 2 form lke Product and Invoice , in 2nd form(Invoice form) i designed

like this

Invoice no (TextBox) Date(TextBox)

supId (DataCombo) SupName(TextBox )

The supId which is in Supplier table, so i bind the SupId from supplier then if i click the combobox SupId corresponding Supname should come automatically in the SupName TextBox

ItemNo(DataComb o) Descrp(Textbox) Price(Textbox) Qty(TextBox) Gross(Price*Qty )

The ItemNo is which is in Product table, first i bind in
dataCombo if i click the combobox ItemNo then the corresponding Descrp,Qty,Pric e would come automatically

So what can i do in this above issue
So i need a help , can anyone tell me how can i do this

[debasisdas]

You need to run SQL query by passing values dynamically.\
Fetch the records
Display in the desired controls.