Invoicing Database

[Jeanne]

I am trying to set up a database that wil keep customer info and create a
printed invoice base on a query. I get that you have to create a relationship
between two tables. (One being the custmer the other invoice detail with the
relationship being the Customer ID). I can't figure out how to make the
invoice number increase and be retained in the database. I need the user to
be asked to imput the invoice date when they open the report. I don't mind
if they have to enter a starting invoice numer. My goal will be to export
the detail of the invoices into an Accounting Program. I would do this in
the accounting program but the deliver/pickup detail for this business is to
specific for the accounting software. The invoices will be printed in
deliver order, etc.
Thanks for your help!

 

[Barry Gilbert]

What about using an AutoNumber column in the invoices table. It will
automatically increment as new records are added. Change the Data Type of
your invoice number column to AutoNumber.

Barry

 

[TedMi]

Autonumber is easy, but it has problems. Namely, if you begin entering a
record, and for some reason its writing to the database aborts, the
just-assigned number will be skipped when the next record is created. Most
accounting programs find this unacceptable. A robust approach depends on
whether you office procedures allow multiple users to create invoices
simultaneously.