Desiging an Invoice

  • Thread starter Thread starter Gregc.
  • Start date Start date
G

Gregc.

Hi

I'm trying to design an invoice whereby a list of items will appear on
an invoice for that customer id. At the moment I have one item per
page for that customer.

Could someone give me a hint on how to do this.

Thanks

Greg
 
When you install Access, it installs a sample database called Northwind.

Open that database. There is a report named Invoice that demonstrates how to
do it.

To trace back how it works, this report gets its records from a query named
Invoices. This query uses 5 tables, but the Orders and Order Details tables
are the 2 important ones to understand.

Basically, since once Order contains many line items, you need a one-to-many
relation between your invoice header table (like Orders in Northwind) and
the invoice line items table (like Order Details in Northwind.)
 
Back
Top