When doing an invoice, how can I enter multiple items?

G

Guest

Here's the scenerio: A company has ordered 3 separate parts all on the same
invoice number. How do I enter all three on the same invoice number, it's
only letting me enter one.
 
D

DL

Probably because your invoice # is a unique ID, however how you resolve this
cannot be answered without knowing something about you db structure.
 
V

Van T. Dinh

Have you check the database structure of the sample database "NorthWind"
that comes with your Access software.

It shows the database structure you need for a *single* order / invoice with
multiple items.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top