
April 8th, 2005, 06:48 PM
|
|
Registered User
|
|
Join Date: Apr 2005
Posts: 2
Time spent in forums: 1 h 13 m 37 sec
Reputation Power: 0
|
|
|
copy selected records to another form
Hi, situation : vb.net and connection with an access database: tables: products, customers,orders,orders subform...
I've' been strugling with this for a long time and can't find the solution.
when customer buys something at our store an need to make a bill for it and need to query the costomers database for
his name and add the costomers name to the order form.
Then i need to query the products table to select the products the customer bought in the store and add these products
to the order subform.
I can query the products table and the customers table in a seperate form but i don't know how i can make a selection and add the selected products or customer to the order form and order subform. ( which is pretty basic i guess but i'm a newbie )
It would be nice if someone had a sample of this or could me point in the right direction
thanks in advance
|