January 1997
Intermediate to advanced
1168 pages
26h 17m
English
This appendix gives you a complete listing of all the tables included in the Time and Billing application. Each table includes the following:
A list of the field names, types, and lengths of each field in the table
A detailed list of the properties associated with each field in the table
This table stores pertinent information about each client, such as the company name, contact name, and phone numbers.
Table A.1. The tblClients table.
| Field Name | Type | Size (Bytes) |
|---|---|---|
| ClientID | Number (Long) | 4 |
| CompanyName | Text | 50 |
| Address | Text | 255 |
| City | Text | 30 |
| StateProvince | Text | 20 |
| PostalCode | Text | 20 |
| Country | Text | 20 |
| ContactFirstName | Text | 30 |
| ContactLastName | Text | 50 |
| ContactTitle | Text | 50 |
| OfficePhone | Text | 30 |
| Fax | Text | 30 |
| Cellular | Text | 30 |
| Home | Text | 30 |
| EMailAddress | Text | 30 |
| ReferredBy ... |