Dear All,
In my form i,v many tables for examples
1.(Table)supplier = SupId varchar(10) primary key,SupName(20)
2.(Table)Product = ItemNo varchar(10)Primary key,Descrp varchar(20),Price float,Qty int
3.(Table)Pinvoice=InvoiceNo int primary key, Pdate datetime,SupId varchar(10),SupName varchar(10),ItemNo varchar(10),Descrp varchar(20),Price 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(DataCombo) 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,Price 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