I am currently working on an order entry form. Currently, I have set up orderid, customer, productdescription, quantity, price, discount, orderdate, discount, totalcost, and netcost as fields. Therefore, when a customer places an order for a single item, say product A, I do not have any problem. You enter all data and save it. However, my problem arises if the customer selects more than one product to purchase for the same orderid. For instance, he may desire to purchase 100 units of product A, 20 units of product B, 30 units of product C. All units are sold on a volume basis. For example the price is $A for a total order of 100 units, $B for 200 units etc. How do I tackle such a scenario. Thanks for you help in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
combobox question for an order entry form
- Thread starter neerajam
- Start date
![[yoda]](/data/assets/smilies/yoda.gif "[yoda] [yoda]")
Not being lazy here.
If you look at the Orders Form in NWind.mdb or NorthWind.mdb, the sample application that's shipped with Access might help you.
Your thread doesn't indicate your table layout or say whether you're using a subform or not.
If the sample doesn't help can you post this info.
Regards
Bill
If you look at the Orders Form in NWind.mdb or NorthWind.mdb, the sample application that's shipped with Access might help you.
Your thread doesn't indicate your table layout or say whether you're using a subform or not.
If the sample doesn't help can you post this info.
Regards
Bill
- Status
Similar threads
- Locked
- Question
- Locked
- Question