Multiple products in one order

P

pisco

I'm trying to set up a database with customer info, product info and order
info. I have a customer table with PK of customer # (autonumber), linked to
order info table by customer number. Also have product info table linked to
order info table by product #. The order table has PK of order #
(autonumber). I have a form containing a subform with formulas for subtotals
and totals. PROBLEM: I can't figure out how to put multiple products within
one order #. Please help!
 
V

Van T. Dinh

The sample database "NorthWind" that comes with your Access software exactly
fits this bill.

Have you looked at "NorthWind" yet?
 
Top