hi to everyone,
Im creating an application which it can show all records of the two tables in single form. its like costumerTable and OrderList. how can i show a record of specific costumer from costumertable together with his product order details from OrderList table. Supposed I have costumerNo field from my costumertable and also i have costumerNo field in my Orderlist table. I also wants to show the order details in datagrid view supposed costumer bought 5 items. can anyone help me find solution. any help we'll be appreciated. thanks
jhowell
0
Newbie Poster
Recommended Answers
Jump to Postlet's say you have variable costumernr with the costumer's nummer and variable amount
adodc1.recordsource = "Select * from tblorder where costumerno = " & costumernr
adodc1.refresh
amount = adodc1.recordcount 'gives you the amount of records with that costumer nummerdo while not adodc1.recordset.eof
'do whatever you want to do …
Jump to PostJoin both the tables using SQL command and display the output on grid.
Jump to PostJoin the 2 tables by use of the LEFT JOIN command in SQL.
All 10 Replies
plusplus
0
Posting Whiz in Training
debasisdas
580
Posting Genius
Featured Poster
ryan_vietnow
13
Posting Pro
jhowell
0
Newbie Poster
debasisdas
580
Posting Genius
Featured Poster
jhowell
0
Newbie Poster
jhowell
0
Newbie Poster
leovicAustria
0
Newbie Poster
ryan_vietnow
13
Posting Pro
jireh
3
Posting Whiz
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.