This table stores the phone numbers for a client. One client can have multiple phone numbers. Each address has a specific phone type.
Field Name | Type | Size (Bytes) |
|---|---|---|
PhoneID | Long Integer | 4 |
ClientID | Long Integer | 4 |
PhoneNumber | Text | 50 |
PhoneTypeID | Long Integer | 4 |
Property | Value |
|---|---|
PhoneID | Long Integer |
AllowZeroLength | False |
Attributes | Fixed size, auto-increment |
Caption | Phone ID |
CollatingOrder | General |
ColumnHidden | False |
ColumnOrder | Default |
ColumnWidth | Default |
DataUpdatable | False |
OrdinalPosition | 1 |
Required | False |
SourceField | PhoneID |
SourceTable | tblClientPhones |
ClientID | Long Integer |
AllowZeroLength | False |
Attributes | Fixed size |
Caption | Client ID |
CollatingOrder | General |
ColumnHidden | False |
ColumnOrder | Default |
ColumnWidth | Default |
DataUpdatable | False |
DecimalPlaces | Auto |
DisplayControl | Text Box |
OrdinalPosition | 2 |
Required | False |
ClientID | |
SourceTable | tblClientPhones |
PhoneNumber | Text |
AllowZeroLength | False |
Attributes | Variable length |
Caption | Phone Number |
CollatingOrder | General |
ColumnHidden | False |
ColumnOrder | Default |
ColumnWidth | Default |
DataUpdatable | False |
DisplayControl | Text Box |
IMEMode | 0 |
IMESentenceMode | 3 |
OrdinalPosition | 3 |
Required | False |
SourceField | PhoneNumber |
SourceTable | tblClientPhones |
UnicodeCompression | True |
PhoneTypeID | Long Integer |
AllowZeroLength | False |
Attributes | Fixed size |
Caption | Phone Type ID |
CollatingOrder | General |
ColumnHidden | False |
ColumnOrder | Default |
ColumnWidth | Default |
DataUpdatable | False |
DecimalPlaces | Auto |
DisplayControl | Text Box |
OrdinalPosition | 4 |
Required | False |
SourceField | PhoneTypeID |
tblClientPhones |