Have you been looking for a way to tame the invoices in your small business? In this article, the first of two parts, we are going to create a fully functioning invoicing system that can be used in almost any environment and situation. Interested? Keep reading.
Invoicing in Delphi: Show Me the Money - Building the Database (Page 2 of 5 )
The database will have only two tables: a Clients table to hold client information, and an Invoices table to hold invoice information. In Microsoft Access create these two tables with the following fields:
Table for clients:
clientno - creates a unique id for each new client.
name - stores the name for each new client or company.
address - stores the address of the company.
email - stores the email address of a client.
phone - stores the phone number of a client.
fax - stores the fax number of a client.
contact - stores the name of the contact that you will be dealing with whenever you are in contact with the client.
Invoices table fields:
invno - creates and stores a new invoice number for every new invoice that is created.
invname - stores the name of the client for which an invoice was created.
invdate - stores the date that an invoice was created.
notes - stores any additional information about the invoice.
Once you've created the tables, the only thing left to do is to connect them to the application. We will do this when we discuss the application code.
Delphi-Kylix 
Looking at the Details for an Invoicing Application in Delphi
