Access order form with multiple cat#s, etc.?

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

Guest

I need a database in which multiple users may fill out a form that lists
order information including multiple items, catalog numbers, etc. I also
would like to be able to generate reports sorted by catalog number or item
description. Do I need to make a separate table for each line item being
ordered? Sometimes up to 10 items may be on one order at a time.
 
I need a database in which multiple users may fill out a form that lists
order information including multiple items, catalog numbers, etc. I also
would like to be able to generate reports sorted by catalog number or item
description. Do I need to make a separate table for each line item being
ordered? Sometimes up to 10 items may be on one order at a time.
Click to expand...

Certainly not a separate table... eep!

Take a look at the Northwind sample database. It does exactly what you
describe, with no limit on the number of items in an order.

In short: three tables are needed:

Orders
OrderID
<information about the order as a whole>

Products
ProductID
<information about each product>

OrderDetails
OrderID << link to Orders
ProductID << link to Products
Quantity
UnitPrice


John W. Vinson[MVP]
 
Thank you so much. I've been trying to teach myself Access this week, and
just couldn't figure this out. Have a great day!
 
Back
Top