Simple inventory

  • Thread starter Thread starter Tonya
  • Start date Start date
T

Tonya

Hi;

I need a simple way to keep track of incoming invoices in
Access 2000. I don't work in the billing dept., but I am
an assistant that has been given the job of listing bills
as they come into the office. I want to be able to type
in the company's name and relevant information one time
and then enter all invoices from that company in table
format so that when I print a report, all invoices that
are related to each individual company are listed
accordingly. I'm new to working with Access. Can anyone
help? Thanks.
 
Open the Northwind sample database that installed with Access.

Open the Relationships window (from the Tools menu).

To handle invoices you will need a similar structure to their orders:
- a Customer table,
- an Invoice table (like their Orders table), that holds the CustomerID;
- an InvoiceDetail table (like their Order Details table), to hold the line
items of the invoice.
 
Back
Top