By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,192 Members | 1,248 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,192 IT Pros & Developers. It's quick & easy.

Doubt in datacombo in vb 6.0

P: 31
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
Apr 13 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 8,127
You need to run SQL query by passing values dynamically.\
Fetch the records
Display in the desired controls.
Apr 14 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.