Multiple products in one order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
The sample database "NorthWind" that comes with your Access software exactly
fits this bill.

Have you looked at "NorthWind" yet?
 
Back
Top