|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 8th, 2008, 07:07 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
adding products to an order form
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. 
|
|
#2
September 8th, 2008, 07:53 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
adding products to an order form
Sounds like a homework project to me...
;^) "csumb" wrote: 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.
|
|
#3
September 8th, 2008, 09:08 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
adding products to an order form
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" wrote in message ... 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.
|
|
#4
September 9th, 2008, 09:41 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
adding products to an order form
And a Customer Table
"Steve" wrote in message m... 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" wrote in message ... 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.
|
|
#5
September 17th, 2008, 06:35 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
adding products to an order form
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. "Klatuu" wrote: And a Customer Table "Steve" wrote in message m... 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" wrote in message ... 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
