multiple orders

[jimd1768]

I have asked this before but could not work out the answer i got(sorry). I need things in very simple terms. I hope someone can assist me.

I have customer table and an order table. Customer table obviously holds all customer info. my problem is orders.

I would like a table/form that allows me to input muliple orders. i.e:

Customer: Smith
Item: Apple
qty: 2
Item: Pear
qty: 1
Item: Orange
qty: 3

I would like all items under 1 order. Currently I have to process them all individually. Can someone help please

Thank you

 

[pbaldy]

Typically this would involve a another table for order details. The order table contains the customer, date, etc, but no product info. The details table has a one-to-many relationship with orders based on order ID, and has fields for product, quantity, price, etc. It is typically displayed as a form/subform. In your example the order table would have 1 record and the detail table would have 3.

 

[ajetrumpet]

Sample

Jim,

Have you looked at this??

It does exactly what you're asking.

I wouldn't say the code is "extremely" simple, but it should be easy to follow.