How do I enter multiple lines (i.e. one order, many products) usi.

[AmandaS]

I am creating a new database for our catering program, and I can't seem to
figure out how to enter multiple products in one order. Can anybody help me
out?? Thanks!

 

[Mike Labosh]

I am creating a new database for our catering program, and I can't seem to

figure out how to enter multiple products in one order. Can anybody help
me
out?? Thanks!

Open up your Northwind database and have a look at the Orders, Products and
Order Details tables. Then have a look at Orders and Orders Subform forms,
and the queries that they use.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), I have a Tutorial called
"CaterIt", which creates a VERY simple application for an in-house catering
service. It might be useful to work through the tutorails (there are 4) to
see how some of this is done.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Rick Brandt]

I am creating a new database for our catering program, and I can't seem to
figure out how to enter multiple products in one order. Can anybody help me
out?? Thanks!

Two separate tables (Orders, OrderItems) with a one to many relationship.
Then use a form/subform for data entry.