471,322 Members | 1,755 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,322 software developers and data experts.

Doubt in datacombo in vb 6.0

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
1 1705
8,127 Expert 4TB
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.

Similar topics

reply views Thread by oaksong | last post: by
6 posts views Thread by R | last post: by
122 posts views Thread by ivan | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.