adding records to a sub form

  • Thread starter Thread starter csumb
  • Start date Start date
C

csumb

i have the following tables products, order detail, orders, customers
i have the following forms products, orders, and sub form order details.
what i am trying to accomplish is to be able to open the products form and
have a customer scan the records and find the products they want and then add
the
qty of the product they want and it will automaticly add it to thier order.
how do i do this

my database is set up the same as the northwind data base.
 
i have the following tables products, order detail, orders, customers
i have the following forms products, orders, and sub form order details.
what i am trying to accomplish is to be able to open the products form and
have a customer scan the records and find the products they want and thenadd
the
qty of the product they want and it will automaticly  add it to thier order.
how do i do this

my database is set up the same as the northwind data base.
Click to expand...

You mean to basically increment the quantity automatically? You would
have to basically grab the relevant line item record and run an update
on that record. You can use a SQL statement for it... where does the
new quantity come from? I guess you could prompt the user for an item
and a quantity and then either update the existing record or insert a
new one...
 
I have a form with all the products and pictures of the products it is bound
to the product table with all the products information, i encluded a field
call qty to order to the table and form

when i pull up the products from ( a continuous from) the customer can
scroll
through and add the qty of the products they want. once they are through I
would like to have a button to confirm the order and plave the items they put
a qty on would then show up on their order form.

if you take a look at the north wind data base mine is set up the same way.

thanks for your help

if you could can you let me know step by step on how to do this.
thanks.
 
Back
Top