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.
Next: Building the Application Interface >>
More Delphi-Kylix Articles
More By Chris Neeman
