adding products to an order form

[csumb]

i have a table listing products
I have a continual form with all the products and its information
I would like to make it so that when I enter the qty to be ordered on the
products form it adds the product and qty to the customers order form.
how do i do this.

 

[Dennis]

Sounds like a homework project to me...

;^)

 

[Steve]

You should have three tables:

TblProduct
ProductID
ProductDesc
Price
Inventory

TblOrder
OrderID
Customer
OrderDate

TblOrderDetail
OrderDetailID
OrderID
ProductID
Quantity
Price

Use a form/subform. Base the main form on TblOrder and subform on
TblOrderDetail.

Steve

 

[Klatuu]

And a Customer Table

You should have three tables:

TblProduct
ProductID
ProductDesc
Price
Inventory

TblOrder
OrderID
Customer
OrderDate

TblOrderDetail
OrderDetailID
OrderID
ProductID
Quantity
Price

Use a form/subform. Base the main form on TblOrder and subform on
TblOrderDetail.

Steve

 

[csumb]

I am hopping someone can help me....

I am looking for a code or how to code

What I have is the following tables
products
order details
orders
customers

the relational links are as follows

customer to orders 1 to many [ customerID] to [ customerID]
orders to order details 1to many [order id] to [order id]
order details to products 1 to many [productsID] to [products ID]

right now i have a combo box in the sub order form called product that adds
the product to the order

what i would like to do is get rid of the combo box

and pull up the product form (listing all the products with a pic of the
products)
and enter the quantity that the customer wants and have it add it to the
customers order and then be able to save it for future reference

This shouldnt be to hard but iam new at this and am not sure how to
accomplish this

Can someone please help me on how to do this or were i can go to get the
answer

thanks.