Table A.2. The Field Properties for Each Field in the tblClients Table
|
| ClientID | Number (Long) |
| AllowZeroLength | False |
| Attributes | Fixed size, auto-increment |
| Caption | Client ID |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| OrdinalPosition | 0 |
| Required | False |
| SourceField | ClientID |
| SourceTable | tblClients |
| CompanyName | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Company Name |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| OrdinalPosition | 1 |
| Required | True |
| SourceField | CompanyName |
| SourceTable | tblClients |
| ContactFirstName | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Contact First Name |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| OrdinalPosition | 7 |
| Required | False |
| SourceField | ContactFirstName |
| SourceTable | tblClients |
| ContactLastName | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Contact Last Name |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| OrdinalPosition | 8 |
| Required | False |
| SourceField | ContactLastName |
| SourceTable | tblClients |
| ContactTitle | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Contact Title |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| OrdinalPosition | 9 |
| Required | False |
| SourceField | ContactTitle |
| SourceTable | tblClients |
| ContactTypeID | Long Integer |
| AllowZeroLength | False |
| Attributes | Fixed size |
| Caption | Contact Type ID |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DataUpdatable | False |
| DecimalPlaces | Auto |
| DisplayControl | Text Box |
| OrdinalPosition | 6 |
| Required | False |
| ReferredBy | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Referred By |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| OrdinalPosition | 15 |
| Required | False |
| SourceField | ReferredBy |
| SourceTable | tblClients |
| AssociatedWith | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Associated With |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| OrdinalPosition | 16 |
| Required | False |
| SourceField | AssociatedWith |
| SourceTable | tblClients |
| IntroDate | Date/Time |
| AllowZeroLength | False |
| Attributes | Fixed size |
| Caption | Intro Date |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DefaultValue | =Date() |
| OrdinalPosition | 17 |
| Required | True |
| SourceField | IntroDate |
| SourceTable | tblClients |
| ValidationRule | <=Date() |
| ValidationText | Date Entered Must Be On Or Before Today |
| DefaultRate | Currency |
| AllowZeroLength | False |
| Attributes | Fixed size |
| Caption | Default Rate |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DecimalPlaces | 255 |
| DefaultValue | 125 |
| Format | Currency |
| OrdinalPosition | 18 |
| Required | False |
| SourceField | DefaultRate |
| SourceTable | tblClients |
| ValidationRule | Between 75 and 150 |
| ValidationText | Rate must be between 75 and 150 |
| Notes | Memo |
| AllowZeroLength | False |
| Attributes | Variable length |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| OrdinalPosition | 19 |
| Required | False |
| SourceField | Notes |
| SourceTable | tblClients |
| Miles | Long Integer |
| AllowZeroLength | False |
| Attributes | Fixed size |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DataUpdatable | False |
| DecimalPlaces | Auto |
| DisplayControl | Text Box |
| OrdinalPosition | 17 |
| Required | False |
| SourceField | Miles |
| SourceTable | tblClients |
| TermTypeID | Long Integer |
| AllowZeroLength | False |
| Attributes | Fixed size |
| Caption | Term Type ID |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DataUpdatable | False |
| DecimalPlaces | Auto |
| DisplayControl | Text Box |
| OrdinalPosition | 18 |
| Required | False |
| SourceField | TermTypeID |
| SourceTable | tblClients |
| HomePage | Hyperlink |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Home Page |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| OrdinalPosition | 20 |
| Required | False |
| SourceField | HomePage |
| SourceTable | tblClients |
لطفا منتظر باشید ...
